Sundaar's Q&A profile

• SQL Server How to store an MS Word doc in a sql 2005 table

  Hello, I want to store the contents of an MS Word document (or a brief Word extract) in a database field. This document could contain carriage returns, boldface, etc. I have tried storing the Word doc in fields of type nchar, text, and sql_variant but they do not keep the Word formatting. I found that the "Extended Properties" attribute of a field seems to retain these properties. (Though if I recall right, Extended Properties has a length limitation and is a pain in the #*&_*^! to access) What is the "right" way to do what I'm trying Keep in mind that we may want to view this document under either "Query Analyzer" or print a hardcopy version. And we'd like both to be intelligible! TIA, ...Show All

• Visual Studio 2008 (Pre-release) GridView padding??

  There seems to be some Padding setting somewhere in the Columns when using a GridView. Where can I change this setting XAML to reproduce (note the white padding between the red columns): < Window x:Class = " XAMLSandbox.Window4 " xmlns = " http://schemas.microsoft.com/winfx/2006/xaml/presentation " xmlns:x = " http://schemas.microsoft.com/winfx/2006/xaml " Title = " XAMLSandbox " Height = " 300 " Width = " 300 " > < Window.Resources > < DataTemplate x:Key = " dataTemplate " > < TextBox Background = " Red " Width = " 100 " Text = " {Binding Mode=OneTime} " /> </ DataTemplate > </ Window.Resour ...Show All

• Visual Studio Team System Creating Area/Iteration Path Nodes

  We are developing an add-in that turns our MS Word documented requirements into Categorized Work Items in VSTS. However, while we can use the Object Model to create the Work Items, the Area and Iteration Node Paths do not seem accessible via the OM. We are trying to be good people and do not really want to be editing the Database directly, so can you please advise if it is possible to create Area/Iteration Nodes using the TFS Object Model Many Thanks Greg Aps sorry I misunderstood the question, well for creating iteration and area nodes I haven't checked, but I suppouse they might be in the Team Foundation Server OM rather than in the WorkItems, but I'm just guessing ...Show All

• Visual Studio 2008 (Pre-release) exception when closing window in button event handler, only when using keyboard

  I ran into an interesting problem, could this be a bug in the Windows.Interop layer In short, I run a win32 app, where a WPF window is opened from managed C++ code. The window has an OK button: <Button Name="okButton">OK</Button> okButton.Click is handled in the C# window implementation, and forwarded to another handler in the managed C++ code, where the window is eventually closed (using Window.Close()). This works nicely, as long as I'm using the mouse to hit the "OK" button. But, when I tab to the button, and hit return, a Win32Exception is thrown after the C# event handler returns (at which point the window is already closed): System.ComponentModel.Win32Exception occurred Message="Invalid win ...Show All

• Visual Studio Team System I want to check whether there is hard code in the codes?

  I want to check whether there is hard code in the codes can you give me some suggestions Oh,I am so sorry. now let me give a example. String str1 = "sammy"; "sammy" is called hard code in our country. the right code should be like this : String str1 = ConstClass.Sammy; can you understand my means. ...Show All

• SQL Server .NET Runtime 2.0 Error Reporting event id 5000 system.nullreferenceexception

  I only found http://forums.microsoft.com/TechNet/ShowPost.aspx PostID=389835&SiteID=17 regarding this error message and it was of no help to me. Background: 3rd party program that extracts users from a AD group and manage user creation i a MSSQL 2000 server. Also sends e-mails using the SMTP service. The funny thing is that the program manages everything correctly, but writes an error in the Event log as it exists (below). Job is scheduled with the SQL server agent and runs with a doamin user that has local admin rights. We have the same setup on a testserver where it runs without problems. Windows server 2003, MDAC 2.8, SQL Server 2000 SP3, .NET framework 2 on both servers. Event Type: Error Event Source: .NET Runtime 2.0 Err ...Show All

• Software Development for Windows Vista Glass-Border like Window-Explorer

  I need a Window with a glass-border like the standard Windows-Explorer, that means Caption with Min/Max/Close Button But it should not display the icon and the window name In the Taskbar the window should be shown as normal, with full name on taskbar button That the way the Explorer appears. I already experimented with different Window-Styles but was not able to achieve a similar behaviour. I found no way to prevent the Title-Bar to display the Window-Name or a way to tell the Taskbar to use a different name(e. g. when setted windowtext to empty). I was able to eliminate the icon from Titel-Bar by setting the WS_EX_DLGMODALFRAME style. Is there an easy/quick way to achieve this, without drawing the caption / border by myself ...Show All

• Visual Studio Express Editions IDE error, help!

  hi again, ok so im really frustrated now guys. after posting my last question and getting the code to work I decided to take a break. i closed the project and closed VBE and left. i come back, try to open the project and it does nothing! there were not any error messages when the ide opened but when i click on the project it didnt load anything. the properties section didnt show my files, the status bar said "ready", the title bar had the project name, and none of the files opened up where the start page is. i dont know whats going on here. any tips michael ok guys here is the update, i was pplaying around with different things and i ended up clicking "reset window layout" under ...Show All

• .NET Development .net runtime 2.0 error reporting

  I'm getting a runtime error on a window's service that I wrote to handle querying and updating a SQL database. I use system.data.oledbcommands to accomplish this, and I have no idea how to research the cause of this runtime error. Where should I post the error message to get some help Thanks! Please Tell us what error you are getting, If its an exception raised from your code to tru put try/catch and write that exception to event log or some other file and then copy paste that error message here so one can investigate about the origin of the problem! Best Regards, ...Show All

• Software Development for Windows Vista Upgrading to Vista, should I uninstall old .NET 3.0?

  In the process of learning WPF, I have installed .NET 3.0 and the Visual Studio 2005 extensions. In preperation for upgrading my OS to Vista Ultimate, should I uninstall the older .NET 3.0 first Also, to get the newest VS 2005 extensions (Orcas, Cider, etc.) should I uninstall the older versions of these extensions first What has been your experience in upgrading to Vista and getting your development environment back in working order Any tips Thanks in advance... Great answer, Brendan! Thank you very much, Bob ...Show All

• Community Chat Firefox 2

  Yay! firefox 2 is being released at 8pm today!! Hooray! just thought i would let you know... After installing XP2 SP2, Firefox really wasn't worth it anymore. It takes too much memory as well. The tabbed browing was nice, but I had something similar with the IE6 addon. ...Show All

• Visual Studio 2008 (Pre-release) Round only 2 edges of border

  Hi! Is there any way to round only 2 of 4 edges of border I can only think of one way, and it seems like a lot of work. Let's say you want the rounded edges to be on the top, with a black border color. You could put two Borders in a grid cell, so that they are on top of each other in the z-order. Set the BorderBrush of one Border to a LinearGradientBrush which draws from Black to Transparent, going from top to bottom. The other Border's BorderBrush goes from Black to Transparent, but the gradient goes from bottom to top. Set the first Border's CornerRadius to some non-zero value. If you get it just right, it should look like one border because the two gradients would blend together at the just right place ...Show All

• Visual Studio Team System Enforce Hungarion notation

  Hello, I know this is a somewhat heretical question, but would it be feasible to write rules to enforce some Hungarian notation like a 'm_' before member variables Any samples I note that C# still uses Hungarian notation for interfaces, requiring the 'I' prefix so maybe this isn't too much of a stretch. Thanks, Jeff Jeff, I've written a rule over on FxCop blog that enforces something similar for private class members. See the download from the following post: FAQ: How do I integrate custom rules with Visual Studio Regards David ...Show All

• Visual Studio Files not checked out while using project upgrade wizard

  Hi, We have a custom project type for which we'd like to support automatic upgrade, using the project upgrade wizard. I've implemented the IVsProjectUpgradeViaFactory interface on the project factory, and everything seem working fine, except the source control integration. I call the IVsQueryEditQuerySave2.QueryEditFiles method on the project file being updated in the UpgradeProject method. In case a project/solution is bound to source control (and is not checked out), VS doesn't try to check the file out from source control, but prompts the user if he wants to allow in-memory edit, or overwrite the file. In case in memory edits are allowed, it just simply edit the file, and will fail (or prompt for overwriting) when QuerySaveFile is calle ...Show All

• .NET Development Trying to intercept the ShowDesktop button

  Hi, I try to intercept the ShowDesktop button (key : win + D) in my WinForm app in order to maintain some forms open (a sort of Desktop post-It effect). Can some one help me Thanks in advance. Garg PS : By the way, handle the resize event doesnt work ;) There are other ways to display the desktop, "Show the Desktop" in the taskbar menu or the "Show Desktop" icon in the Quick Launch toolbar. Try handling the WM_NCCALCSIZE message in the form's WndProc(). ...Show All