Groups | Blog | Home


Archived Months
June 2003
July 2003
August 2003
September 2003
October 2003
November 2003
December 2003
January 2004
February 2004
March 2004
April 2004
May 2004
June 2004
July 2004
August 2004
September 2004
October 2004
November 2004
December 2004
January 2005
February 2005
March 2005
April 2005
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
November 2006
December 2006
January 2007
February 2007
March 2007
April 2007
May 2007
June 2007
July 2007
August 2007
September 2007
October 2007
November 2007
December 2007
January 2008
February 2008
March 2008
April 2008
all groups > dotnet ado.net > august 2003 > threads for tuesday august 5

Filter by Day: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31

Repeatable bug with SQLTransaction object
Posted by Dano at 8/5/2003 11:06:34 PM
Hi all, I am always reluctant to call something a bug in the very fine .Net framework seeing as how I am relatively new to it. However I have come across some behaviour dealing with transactions that I don't think by any stretch of language can NOT be called a bug. If it is my own lack of exp...more >>


updating NULL values
Posted by Dino M. Buljubasic at 8/5/2003 9:25:38 PM
How can I update fields with a colum as NULL value in VB.net Something like this: UPDATE table1 SET colMycolumn = 22 WHERE aCol = NULL Thank you, -- Dino Buljubasic Software Developer http://rivusglobal.com ...more >>

binding question - add/edit with 2 forms
Posted by mtagliaf NO[at]SPAM adelphia.net at 8/5/2003 7:36:05 PM
Can someone tell me how to accomplish the following: Form 1 contains a grid (Janus) bound to a DataTable within a Dataset. I don't like editing in the grid, so I have Add/Edit/Del buttons next to the grid. When the user clicks "Add", I want to "send" the DataTable to another Form (construct...more >>

Connection Pooling
Posted by RickT at 8/5/2003 2:44:53 PM
How does using .NET Connection Pooling with Trusted Connections work inside SQL2K? Can the server use the same connection for 2 different users, or does each user get their own connection? - Rick ...more >>

Password problem
Posted by FF at 8/5/2003 2:35:16 PM
After installing Visual Basic .Net 2003, I am having trouble connecting to an Access database. I use a dataadapter and the Querybuilder with a Jet 4.0 OLE DB provider and everything works fine until I press the finish button, then I get the error message: "Format of initialization string ...more >>

Defining constraints
Posted by Tom Archer at 8/5/2003 1:53:00 PM
I have a table where I want to store either a location to a picture (such as a URL) or the actual binary data that comprises the picture. Since these are two drastically different data types (string and binary, respectively) I've defined a column for each possibility. How do I define a c...more >>

crystal Report keycodev2.dll Problems
Posted by volkan at 8/5/2003 1:23:29 PM
Hi, My problems Windows Application Deployment phase Crystal Report "keycodev2.dll" error to give Thanks. ...more >>

.NET SQL Float rounding problem
Posted by JCardinal at 8/5/2003 12:38:30 PM
Hello, I've run into something strange, I have the following SQL parameter (c#): cmd.Parameters.Add(new System.Data.SqlClient.SqlParameter("@_rate", System.Data.SqlDbType.Float)); This is for a simple stored procedure that updates a float value in a SQL server 2000 (MSDE) table. The foll...more >>



Microsoft.Jet.OLEDB.4.0 and CSV files
Posted by tobyknott NO[at]SPAM hotmail.com at 8/5/2003 11:57:13 AM
I'm using the Jet OLE DB provider to select data out of a .csv file into a dataset. '---------------------------------------------------------------------- Dim ConnectionString As String = _ "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\\path\to\file;Extended Properties=""Text;HDR=NO;""" ...more >>

returning many datasets from a single stored procedure
Posted by ckostenko NO[at]SPAM freemarkets.com at 8/5/2003 8:31:07 AM
Hello, I've been told that it is possible to get back multiple data sets from the same stored procedure. A practical application to this is returning a count(*) in the first select statement and returning the actual data in the second dataset. Is it possible to do this? I thought a SP only ...more >>

saving tables as .xls
Posted by Bernie Yaeger at 8/5/2003 3:06:02 AM
There must be a simple way of saving an sql table as a .xls file using ado ..net, but I can't find anything on it. Any help would be much appreciated. Bernie Yaeger ...more >>


DevelopmentNow Blog