Xin Zhang's Q&A profile

• .NET Development Update not writing default values to the database

  Hello,   I'm using a TableAdapter to update a table which has some default values set in SQL Server. However, every column that I leave blank gets inserted with a null value instead of the defined default value for the column. Is there anything I am missing or is this the default behaviour Thanks in advance for any help given.   Regards, paulo The dataset designer does no ...Show All

• Visual Studio Tools for Office strange vsto security issue

  I have a strange security issue using asp.net 2.0 and vsto. I have a web form that launches an excel file with .net code in it. This requires certain .net security settings to be set. The site is at http://localhost/app . So we set FullTrust for http://localhost/app/ *. This does not work however and throws the following exception: Request for permission of type 'System.Security.Permissions.SecurityPermission, mscorlib, Version=2.0.0.0,C ...Show All

• Windows Forms Making a form a control

  Hi This might be a real stupid one to some people, but I am a fresh convert from VBA and going through a bug learning curve. I have designed a form with treeview control and its own properties and methods. I would like to also create some inheritance forms from this. I am using Infragistics UltraExplorerBar. Pretty impressive and worthlooking at. If I set the control style to control container, I can very easily drag controls such as bu ...Show All

• Visual Basic WebPage Interaction

  HI I Hope this is the right place to ask this! I have a browser window which i use to connect  to my bank accounts web Page. I use SendKeys to communicate with the webpage and to download my accounts. I have used 'Microsof Money' in the past and they are able to do everthing automatically without even opening the webpage! I wonder if any of you know how this is acheived any clues would be appreciated Thanks in advance Mike Pooley Hey ...Show All

• SQL Server Query Designer in SQL 2005 is total %#%!@

  What happened to the Query Designer   It's a modal window that doesn't allow you to drag tables from other databases into the query.  SQL 2000's verion of Query Designer was so much better than 2005.  What happened   Are the developers at Microsoft completely retarded   Also, why do I have to log into my database servers everytime I open "Server Management Studio"   Who thought up that nice feature   Probabl ...Show All

• .NET Development Can't get a TCPClient Connection working

  I've been working on this same thing for quite some time now. I'm trying to make an admin console to manage my IRC server, but I can't get past the beginning stages of establishing and maintaining a connection. I finally copied the code out of the project and made a new one with just a textbox, trying to just dump every bit of data I'm sent into that box, but even that isn't doing anything now. I've looked into IRC communication, so I know I'm u ...Show All

• SQL Server A Problems after the install of the Hotfix

  After installing SP1 and then the hotfix: http://support.microsoft.com/Default.aspx id=918222 We now get the following error when trying to work with date parameters in Report Builder: Query (6, 117) The '[VBA].[DateSerial]' function does not exist. ---------------------------- Semantic query execution failed. ---------------------------- Query execution failed for data set 'dataSet'. ---------------------------- An error has occurred duri ...Show All

• .NET Development Return value in value types

    Sometimes, when I need to "say" something went wrong in a function but I don't want to throw exception I return null. This is possible only if the returned type is reference type (Class) . Whenever it is a value type , the null option is not valid . in literals I can return -1 but what about structs Thanks   If you observe .NET, you can see that some structs has a static (Shared) property c ...Show All

• Windows Forms SelectAll in TextBox

  Hello, I use the methods Select() and SelectAll() to select all the text in a TextBox in the "Enter" event. It works when I hit TAB, but it doesn't work when I perform a mouse left click (the text is selected a very short instant and it is automatically deselected). Thank You for your response You may not want the left click to select everything. Normal behaviour for mouse left click in a textbo ...Show All

• Smart Device Development Creating Custom Controls for the Toolbox and .NET 2005

  Hello, I am currently working in Visual Studios 2005, C#. I am attempting to make a custom control that can be used through out many different programs in our mobile department. I have followed numerous on line examples on how to do this, and I can not get any of them to work. My biggest problem is that after the control is created, I add a project to my solution and reference the new control. At that point, the new control is not visible in th ...Show All

• .NET Development Determine which choice element is present - best way.

  If I have a comlexType which has a choice of mutually exclusive elements, what is the best way in C# code to determine which element is present in an instance document <xs:complexType name="ConnectionType"> <xs:choice minOccurs="1" maxOccurs="1"> <xs:element name="Queue" type="Queue" /> <xs:element name="Folder" type="Folder" /> ...Show All

• Visual Studio Express Editions How do I view Console.Writeline?

    I'm rather new to programming. I've read two VB Express books and everything that I could find concerning Console.Writeline, and yet I still cannot figure out how to view what I write to it. When I use Debug.Writeline, I can view what I write to it in the "Immediate" window. I guessed that I should be able to view Console.Writeline in the "Output" window. Is that correct I tried things like the example below, and nothing ...Show All

• Visual C# Dirctory.move won't fire filesystemwatcher event

  Dirctory.move won't fire filesystemwatcher event       Background: I have a server app that uses the filesystemwatcher that monitors a target folder and performs some operation on it when a sub-folder appears in it. (a) When the service is run and I do a cut and paste or copy and paste it works great. (b) When I move a folder there (drag&drop) however, an event doesn't fire. Problem:  I have a seperate client ...Show All

• Visual Studio Team System Excessive cpu load when diddling with unit tests?

  I've found when I make code changes within a unit test that cpu load goes scale high for a number of minutes...  For instance, if I have a unit test class named 'SomeTest' and I change the class name to 'SomeTest1', I end up getting ~100% cpu load for ~10 minutes.  The same goes for changing a test-related attribute.  It also includes deleting a test method.  Is there something I can do to mitigate this as it makes working on ...Show All

• SQL Server Partially solved the problem {OLE DB error - TCP Provider: No connection could be made ...}

  All, -> SQL Server 2005 Standard set as a named instance, runs as a local system -> SQL Server protocol enabled: TCPIP (configured to listen on port 1433 with use of dynamic ports disabled) -> Remote connections through the SQL Server Surface Area Configuration. Server starts successfully. But, I received the following error on trying to process a cube from BI studio is - OLE DB error: OLE DB or ODBC error: Login timeout exp ...Show All