Boozy's Q&A profile

• SQL Server Condensed Type vs Data Type

  In the database diagram, it used to be that Data Type was int, varchar, char, etc. and Condensed Type was int, varchar(30), char(5), etc.  Why was this changed in SQL 2005   Is this a bug My assumption is that it's because of the new data type "xml". The help says as follows:- Condensed Data Type Displays information about the field's data type, in the same format as the SQL CR ...Show All

• Visual Studio 2008 (Pre-release) Is there an April CTP?

  It's not a request, but just want to know if there is such a plan. Thanks! One feature I'd like to see soon is a less-buggy text editor. Right now in VS2005, XAML files quite frequently lose their ability to do much from the keyboard (things like backspace, delete, cut, copy, paste, selection, etc.) and I have to resort to mouse commands to do stuff. I can ctrl-tab to another window and back to make it work again, but I'm looking forwar ...Show All

• Windows Forms 3 tier design

  Is there any Microsoft examples in vb.net that show proper design standards.  Im pulling my hair out trying to decide should i fill a pull down combo box with a bound datatable,dataset,array,etc. Should i never bring a dataset to the UI layer&n ...Show All

• .NET Development How can I retrieve the exact HTML document's original source code?

  I have a unique situation. A hosting website is inserting extra code in front of my DOCTYPE tag, throwing IE into quirks mode. Of course in quirks mode it's parsing the HTML differently, and what's worse, the extra tags are changing the document's structure. So when I retrieve the document's "source" with innerHTML open the document for writing write a new DOCTYPE tag write the "source" back into the document ...Show All

• Visual Basic Problem with 3219 Error: Operation Not Allowed in this Context

  I have a very simple VB Application I am trying to create. I have gotten it to work in terms of queries in SQL Server but I am having trouble moving it into Visual Basic. I need to resolve this in the next day or two. Any help is greatly appreciated. I am more of a database person than a front-end person. It keeps blowing up at this line: varData = rstCountErrors.GetRows(iNumRows) This is my entire code: Private Sub dgdCount_Click() End Sub Pr ...Show All

• Visual C# How can I assign a ContextMenuStrip to a ToolStripMenuItem?

  The title says it. Please help. Check the links... http://msdn2.microsoft.com/en-us/system.windows.forms.toolstripdropdown.opening.aspx http://msdn2.microsoft.com/en-us/library/system.windows.forms.contextmenustrip.aspx ...Show All

• Visual C# ExecuteScalar erro

  { SqlConnection conn = new SqlConnection (); conn.ConnectionString = "Data Source=(local);" + "Initial Catalog=bd;" + "Integrated Security=SSPI;" ; SqlCommand sqlComm = new SqlCommand ( "SELECT * FROM utilizador WHERE user=@user;" , conn); sqlComm.Parameters.Add( "@user" , SqlDbType .VarChar); sqlComm.Parameters[ "@user" ].Value = user.Text; ...Show All

• Windows Forms SplashScreen in my application

  Hi, I want to include a SplashScreen to my Visual Basic 2005 Application, when my application is started. I have added the standard SplashScreen-Item and changed the settings. When my applications is loaded the SplashScreen is showed for less than 1 seco ...Show All

• .NET Development Forcing ActiveX to load v1.1 when v2.0 is installed

  I have an ActiveX control (inproc) that is written in Managed C++.  When Internet Explorer (or any other ActiveX host) loads it, how to I make certain that the 1.1 runtime is loaded instead of the 2.0 runtime if both are installed on my machine I've tried a MyActiveX.dll.config file requiring the appropriate runtime, but that doesn't seem to do the trick.  Any other ideas That's what I was afraid of... I think it would be bad fo ...Show All

• SQL Server Encryption and recovery on standby machine

  Hi there, to follow on my question in the other forum, I have a database with triple des encrypted columns Master key created, certificate and symmetric key using certificate. Values inserted into table (encrypted) Can select etc, all works fine. Back up and restore database on another server, decrypting the data results in NULLs being returned. Backed up and restore the master key, cerficate, etc but either it completes successfully ...Show All

• Visual Basic getting application data folder!!

  i want to know if there is a api for getting application data folder in windows xp!! like getsystemdirectory or getcurrentdirectory n does the path like( c:\documents and settings\"username"\local setings\.. )does this type of path varies for different windows versions!!:) Hi, For ClickOnce published application, I think IsolatedStorage is a better solution. .NET Framework 2.0 introduces a new Application scope that will move with your a ...Show All

• Smart Device Development Print the routing table? Is there software similar to cmd: route print?

  Anyone have any suggestions here I need software with similar functionality to route print and I've tried VXUtil with no luck. Thanks! See the following post on places where you can post non VS 2005 questions http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=223605&SiteID=1 ...Show All

• Windows Forms error when log in window(too many parameter)

  my computer using win 98,there is bad sector with my harddisk,the win.com file is missing,i get another file from another computer which using win 98 too,but when i start my computer,it stay at dos ,and say it is too many parameter,but i can enter safe mode of window.What can i do                           & ...Show All

• SQL Server Full Text Issues

  Hi i am really new to full text searching, I have created a catalog using: sp_fulltext_catalog 'textcatalog','create' and now i want to add a table with: sp_fulltext_table 'Product', 'create','textcatalog', 'ProductID' where product is a table in my database and productID is the primary key to that table. The primary key cannot be null, But i get an error: 'ProductID' is not a valid index to enforce a full-text search key. You must specify a u ...Show All

• Visual C++ Compiling bug?

  alright, now i get just another error. its very weird. it doesnt matter if i build on the VS2005 prof edition, or the express edition. anyway... public ref class CTree { private : ArrayList^ _TreeNodes; public : CTree() {} void AddTreeNode(VCNode^ Node){ TreeNodes->Add(Node); } void Repaint(TreeView^ Tree){ for ( int i = 0; i <= _TreeNodes->Items->Count; i++){ if (_TreeNodes->I ...Show All