BobPaul's Q&A profile

• Visual Studio Team System Solution keeps losing SCC binding

  I have a solution with 11 projects, all bound to SCC paths.  The entire solution and all of the projects are in a single directory hierarchy, with the filesystem hierarchy exactly mirroring the SCC hierarchy and the solution/project hierarchy. Whenever I close VS and re-open it, the solution SCC bindings are lost.  I can go into the Change Source Control dialog, select the .sln file and click Bind and the binding is re-established, but next time I close VS it'll be lost again. Is this a known bug, or is there something special going on here that deserves further investigation There were a number of problems related to re-bind ...Show All

• SQL Server What is up with Defaults in 2005????

  To keep inline with BOL, I have gone away from the CREATE DEFAULT and sp_binddefault when using defaults, and have gone to using what BOL suggests and specifying the default on the column definition when adding a column. However, I cannot find anywhere how to REMOVE a default when applied in this manner. I need to delete a column via T-SQL and according to BOL it says a column cannot be deleted when it is associated with a default that is defined with the DEFAULT keyword (such as in my case), as follows: CREATE TABLE [dbo].[Test] ( [icheckno] [int] NOT NULL DEFAULT 0, ) ON [PRIMARY] GO OK, fine, so how do I remove the DEFAULT to dro ...Show All

• Visual Studio Express Editions Append to XML file

  I'm trying to make an application to keep track of recipes, but I can't figure out how to append to an XML file.  I've searched online, but I'm not coming up with the answer.  Someone suggested a dataset, but I can't figure out how to use that to append to an XML file.  I'll show an example of the code and what the XML file currently looks like. Private Sub Save_Click( ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Save.Click Dim xtwcurrent As Xml.XmlTextWriter Dim lines As String () = Directions.Lines Dim clines As String () = Comments.Lines xtwcurrent = New Xml ...Show All

• Visual C++ Calling a Public Windows Form function from another Form

  I am having a problem calling a public function I created in one windows form from another.  I am using VC++.NET 2005. Here is the snippet of code: From second windows form: public ref class frmEnvWindow : public Form { private : Queue^ cmd_queue; public : frmEnvWindow( void ) { InitializeComponent(); } void Set_Queue (Queue^ pqueue) { cmd_queue = pqueue; } And in the main windows form if (!Display_Showing) { graphX_Display = gcnew frmEnvWindow; graphX_Display->Set_Queue(cmd_queue); graphX_Display->Show(); Display_Showing = true ; } It also is not seen in the intellisense function. error ...Show All

• Visual Basic Populating per like statement

  I have a large Access table with words, definitions,... what I have been trying to do for too long is to type a word pattern (p r or t n* ) in a textbox and after a button is depressed to have a datagrid populated with words similiar to what is requested. I have utilized the data source wizard to add the source, added the adapter, binding source and dataset. I have dragged the datagrid into the form. when started it populates. Then i added the textbox (txtFind) and button. i right-clicked on the adapter, went into the query via the dataset designer, added like txtFind.text in the filter area for the word field, and added : Private ...Show All

• Windows Forms I need help about drawing rectangle on htmldocument

  hey All, I want to draw a rectangle on Html document using mouse event(mouse move,mouse down,mouse up). Infect i am developing a form which contains Webbrowser Control , when this control shows some web site in it , means after documentComplete event. i need to draw a region on this document just like drawing region for capturing some part of screen in many softwares. help me ASAP. Thank you in advance. Hi, Could you be more clear in what you would like to achieve...so that some of us will try helping you. Thanks! Bhanu. ...Show All

• Visual Basic Is it possible ?

  Is it possible to change an existing desktop VB.NET-SQLServer application to a LAN/ network based (not web) application means if u access the same Application exe from 2 or more pc in a LAN then wat will be the problem is it possible Or every application must be client-server type to run in LAN Thnx in advance.   wat if, my app uses a Global variable in a Module then is there any kinda conflict will arise betwn 2 PC in LAN ... like if that variable uses to store a "username" then ...Show All

• SQL Server Meta Data

  Hi, I want to get meta data information for DTS packages, I don't see anything when I click on Meta Data Services Package. Also, I get an error when I click on Meta Data "An error occurred while trying to access the database information. The msdb database could not be opened." Need help.. Thanx SQLBob Hi, SQLBob, I was having the same problem. On the assumption that you are running under Win2003 SP1 look for hot fix 912812 on the operating system. Remove it and Meta Data goes back to working. Uncle Davy ...Show All

• Visual C# FileStream and writing out in chunks

  hi all, i have a byteArray i read into from a httpposted file, i would like to write it to a new filestream in chunks of a size i specify. I can write the file out no problem at once, using myFileStream.Write(byteArray,0,postedFile.Length) but i want to break it up into chunks so that it stores smaller amounts at a time and doesn't kill the aspnet_wp. i have tried FileStream newFile = new FileStream(fullSavePath + sFilename, FileMode.Create); int pos = 0; int length = 128; while(pos < nFileLen) { if(length > (nFileLen - pos)) { length = nFileLen - pos; } newFile.Write(myData,pos,length); pos = int.Parse(newFile.Length.ToString() ...Show All

• Windows Forms How can I add same project in two different solution pointing to the same project in VSS

  Hi All, I am trying to add the same project from VSS into two different solution. When I try to add the same project (File-Source Control-Open From Source Control) in different new blank solution, it overwrites the new solution name with the old one, which means it never allows me to create new solution. FYI, - we cannot use GAC - we still need to shar ...Show All

• SQL Server Foreach NodeList Enumerator

  Does anyone have any experience of using the NodeList enumerator in a Foreach loop BOL is a bit light on this. I want to enumerate over an XML Document that is passed into my package. The package is executed from a .net application. Has anyone done anything like this Any demo material Should I pass the XML Document into an SSIS object variable or a String variable Can the NodeList enumerator enumerate an XML document that is stored in a String variable etc... Thanks Jamie Since others might be struggling with figuring out the InnerXPathString I thought I would post my experiences. I have the following recursive schema in the ...Show All

• Visual Studio Team System Error 28906. WiDbLoc: Failed to localize a field in the database.

  Hi I am gettings this error: Error 28906. WiDbLoc: Failed to localize a field in the database. I have SQL 2005 installed on Windows 2003 Standard (SP1 etc.) it is running New Zealand English and TFS Beta 3 Refresh (database only) On another Windows 2003 Standard box I am trying to install the application tier and that is when I get the error. And the section of the error log (if that helps ) [11/01/05,17:18:42] Microsoft Visual Studio 2005 Team Foundation Server (services) - ENU: ***ERRORLOG EVENT*** : ERROR:Error 28906.WiDbLoc: Failed to localize a field in the database. [11/01/05,17:18:45] vs70uimgr: Entering DisplayMessage() method. [11/0 ...Show All

• Visual Studio Express Editions Installing over VS 2005 Beta 2

  Question 1: What is the correct way to install VS 2005 Standard over VS 2005 Beta 2. Should Beta 2 first be removed and then install the Standard VS or is it ok to install over the Beta 2 version. Question 2: I have been trying to use the different starter kits and the .vsi files are not recognized by VS 2005 Beta2. I am hoping that by installing VS 2005 Standard this will take care of this issue or is there something else I need to do to rectify this problem. I have searched for answers but have not come up with anything that is helpful. Any feedback is appreciated. Thanks John You can't i ...Show All

• Windows Forms Trapping CTRL + B etc events

  How do I go about trapping multiple events like CTRL + B, CTRL + U. I know there is a way using ProcessDialogKey but am not being able to work that out. Any help would be great Thanks Sergey - that's what I was looking for... didn't know you could do this: KeyDown += new KeyEventHandler(OnKeyDown); Cheers, Mike. ...Show All

• .NET Development Are GAC assemblies reference counted?

  In the old win32 world, if you had dll's you wanted to share, you could put an entry in the registry under "SharedDlls" or something. The dll was reference counted, so if no other application (other than the one that installed the dll) used the dll, it would be removed when the app was uninstalled. If another app had been installed since that used it, it would be left behind when uninstalling the original application. Does anyone know if there is a simlar mechanism for GAC assemblies There are trace references which are somewhat similar but not quite the same. See http://blogs.msdn.com/junf ...Show All