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 >>
Don't see what you're looking for? Search DevelopmentNow.com.
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 >>
|