Jay Burt's Q&A profile

• .NET Development passing dbnull to splserver express

  I have an application i'm writing connecting to sql server express. there is a field call PayDate which is a text field and it passes the date to a coloumn in splserver which is a "date" type and allow nulls is checked. I can add and update the dates changed with no problem, but what I want to do is when the date on the textbox form is removed, I want to pass a "null" back to the PayDate column in sqlserver so it shows as "NULL" . When I used "mySQL", I had no problem passing a null back, but with sqlserver I can't seem to get this to work. Is there a way that when I remove the date from the textbox on the form and press "save" myBindingSource.EndEdit() myTableAdapter.Update( Me .myDataSet.myTable) I can pass ...Show All

• SQL Server System.Data.ConstraintException Visual Basic 2005 Express / SQL 2005 Express

  This problem only occurs after deployment, not when debugging. In the table I am having a problem with I have an ID field designated as the primary key with the identity increment set to 1 and the identity seed set to 1. There is no data in the table when deployed. I can add records to the datagridview control but when I try updating the dataset I get this error indicating that the ID field already has a value of 1 present. If I close the application and re-start it, the exception no longer occurrs when I update the dataset. I am including the code to update the tables incase something is wrong there. Any suggestions Private Sub UpdateMemberTable() Me .Validate() Me .TblMembersBindingSource.EndEdit() Me .TblMembersTable ...Show All

• .NET Development Why is this SQL statement slow?

  I have a database with 1,000,000 records. I am trying to implement a paging technique using the SELECT TOP statement. On an SQL server db, it is relativley fast. In access DB which is linked to the table in the SQL server DB, it is slow. I am running it through an OLEDB DataAdapter. It is slow when I use a statement such as : SELECT TOP 5 * FROM MyTable ORDER BY PrimaryKey It will speed up when I modify the statement as follows: SELECT TOP 5 * FROM MyTable WHERE PrimaryKey < 'Small Number' ORDER BY PrimaryKey Why does it speed up when I modify the WHERE clause to return only a small number of the records Shouldn't the TOP statement make it fast by itself I'm baffled. Any insight would be greatly appreciated. ...Show All

• Commerce Server Commerce Server Web site as a Visual Studio file system Web site

  Hi, I was reading the MSDN documentation on creation of a Commerce Server Web site and it states that a Commerce Server site must be created as an IIS web site and not a file system site in VS 2005. Link to the same : http://msdn2.microsoft.com/en-us/library/aa545520.aspx Can someone explain why a Commerce Server Web site cannot be created as a Visual Studio file system Web site Regards. Husain Jagmag Hello Husain, I Think that you have to use IIS web site and not a file system site VS2005. First because every time you access to a file system site, you access it through a randomized port number, and Commerce Server needs a fixed port number. Second because the Commerce Server packager (Program that generat ...Show All

• Smart Device Development Why Can not I connect the WM5.0 device by the remote process viewer and remote heap walker?

  For the first time, I installed the Visual studio 2005 professional Edition (VS2005) first and the the Windows CE 5.0 with Platform builder 5.0 later. I find I can connect the WM5.0 device with the remote process viewer and remote heap walker provided by VS2005 and all data can be obtained successfully. However, when I reinstalled my system by installing the Windows CE 5.0 with platform builder first and VS2005 Professional Edition later, I find I can not connect the WM5.0 devices with the remote process viewer and remote heap walker (the other tools are OK) provided by VS2005 although the Activesyn shows that the WM5.0 is conncected correctly. Anyway, all the remote tools provided by VS2005 can connect with the emulator. By the remo ...Show All

• .NET Development XML and Daylight Savings Time Change - Strap on your seat belts...

  I've searched around a bit, and it seems no one has woken up to the fact that the daylight savings time change which is now rolling out is going to mess up applications which use UTC time in a big way. Our regression tests began failing a week ago, and it turns out the culprit was some saved xml data which of course has dates in UTC format. When run on a machine with the DST changes installed, the test program brought the XML file into a dataset with ReadXML and the times changed from midnight to 1 am in the test data containing dates in March 2005 (magically, the 2nd Sunday in March). Unfortunately, the DST change makes it as if the past data (e.g., March 14, 2005) was in daylight savings time, which it was not before the change, thus ...Show All

• SQL Server pre-filter data in SQL

  I need to query the Employees table in the ABC database to find all employees who report to EmployeeID 5 (indicated by a value of 5 in the ‘ReportsTo’ column) and who have the word ‘Sales’ in their job title (i.e the Title column). In my database the Employees table is very large so you want to pre-filter the data before doing more complicated processing on it. How would I use the following statement to to pre-filter the data SELECT * FROM EMPLOYEES WHERE ReportsTo = 5 Hello, SELECT * FROM EMPLOYEES WHERE ReportsTo = 5 AND Title LIKE '%Sales%' Now when you say pre-filter, do you mean place the above resulting resultset into a temp table so you can perform further processing If so, you could: SEL ...Show All

• Visual Basic How to verify files exist... kinda...

  Hello, I'm trying to verify that each file in a list exist. I can successfully read the text file (which contains the list of files) into an array. (Each containing one filepath.) Each path has quotes around it and I have easily removed them. I then created an array and put the file path to every file (in the specified directory) into each dimension. My problem now is, I need a way to compare the two lists, verifying that each file that exists is in the other list. So I suppose that I am not looking for a way to verify files exist but rather that each file that does exist is in my list. Understand I have considered multiple ways of doing this but they have either failed or I have found that they are not what I am looking fo ...Show All

• Visual Studio more info. . .

  It appears that the standard VS 2005 documentation has been registered twice. In the contents explorer I have two entries for Dev Tools/Ent Servers/.Net Dev/Mobile & embeded/Office Solutions/Web Dev/Win 32 & Com/Knowledge Base In the ide, when I have dynamic help showing, two identical topics are displayed for any selected item. In the help system, if i click a link, a dropdown displays two identical topics for me to select from. Any idea how to fix this Hello Blair, From your description it looks like you first installed MSDN Library for Visual Studio 2005 and then you received MSDN August Library. During August library installation when prompted you selected to keep MSDN library for Visual Studio 2005 and als ...Show All

• SQL Server Microsoft SQL Server 2000 Reporting Services

  I understand that this is available for free but I have not been able to find it for downloading. Can anyone point me in the right direction for this Do you know does it really require alot of resources like I have been reading. People recomending a seperate SQL box just for thes reporting services. Please advise. You can download evaluaiton copy from here . Also you can download SP2 for RS 2000 here . ...Show All

• SQL Server DataGridView: How can I update data in a DataGridView?

  Hi guys, Im having some issues understanding how to manipulate the data that is in my DataGridView The View is created by calling a stored procedure from VB code and works on two tables: people pswds The columns required from Table people are (personid, userid and sort). The columns required from Table pswds are (comment and activeuser). Table people is parent table while pswds is the child table. The Relationship works between both tables using primary keys from both tables: which is called personid in both. The link below shows the Relationship Diagram for the Two tables: http://cale.csd.anglia.ac.uk/~csd03ib/images/RelationTables.bmp The code for the Stored procedure can be found at the follow ...Show All

• Visual C# DataTable and DataStorage

  I have two Datatables say Table1 and Table2... and both contain some data....I passed this data to the below class.... private DataTable errorStore = null ; private DataTable infoStore = null ; public DataTable TheErrors { get { return this .errorStore; } set { this .errorStore = value ; } } public DataTable TheInfo { get { return this .infoStore; } set { this .infoStore = value ; } } public DataStorage( DataTable errData, DataTable perInfo) { this .errorStore = errData; this .infoStore = perInfo; } public DataStorage() { // // TODO: Add constructor logic here // } //Instantiate the class and pas ...Show All

• Visual Basic Accessing LAN server

  When i accessing computers in my LAN for some computers i need to enter password and user name. My database is on the server computer. If i previously access the server my program work. If I didn't access the server program thru me a error then i don't heve premission to access the database file. Can i enter user name and password true code I can't share access to server so i must enter user name and password. THANKS Perhaps this article helps... ...Show All

• Visual C++ How to get control's relative position and it's size in a window / dialog box?

  Hi all, Actually I am trying to give a different appearance to my vc++ application. i.e. i like to change the appearance of all controls in my dialogs. So I like to draw control's border in my own after removing its border property. So can any one tell me how to get relative position of controls in window / dialog any suggestions would be appreciated. Purusothaman A Thanks priyasophi . I am also a starter. Regards, Purusothaman A ...Show All

• SQL Server Refresh selection in Query Analyzer?

  I add a new table and I want to see it in my list, I can go to EM and refresh there but it appears I have to close QA in order to see the new table. Is there a refresh option in QA to see my new object thx, Kat ...Show All