the source DB has a table with 3 columns
ColumnA (primary key, uniqueidentifier)
ColumnB
ColumnC

Can anyone tell me the best way to programmatically populate a dataset from a
.csv file?
Thanks,
Brian

I am a newbie to .Net. I run into problem when I try to assign null value
from the database to, say, a textbox.
Say if I had a simple table called "Contact" in the database and it has
three fields: ContactID, Name, Email. If I want to display the data. I would

1) sending the code below always times out for the current day
2) sending the code below never times out for any other day except the
current day
------------------------------------------ code snippet

I have an SQLServer table with 2 colns that I need to compare. The
colns and their sql server datatypes are:
sTStamp -> Binary (length 8)
dTStamp -> int (length 4)

I have the follwing "decision-making" problem:
-  I want to construct an interface with a few radios, listboxes etc so that
a user can, by selecting some or all of them, dynamically create an SQL
string. This is fine, and i have an example to consult.

I am using a stored procedure on SQL server to test for a few
conditions, setting a BIT depending on the result of each test.  Each
BIT parameter is defined as an output param in the stored procedure and
set to 0 by default.  From my code, I define each parameter, add them to

All,
I'm using the DataAdapter from IBM iSeries to connect to our AS/400.
When I fill the dataadapter, all my string values are converted into
Binary values. The response from IBM is to upgrade our AS/400 OS

How do I set the @@Identity parameter for data that has been read in from a
database?  I have read in data via a command (SELECT statement) and am
trying to build a good UPDATE statement and want to use the @@Identity
field.

May in VB.NET is similar code without Dataset
as in VB6 ADO  command rst.addnew
for adding simple row to database mdb or MSDE.

Ok I'm starting a new post because I'm stuck. I have included code for a
test datatable
bound to a datagrid. I want after a row is deleted for the AutoIncrement to
start from the last number

I have a situation where a SqlCommand incorrectly throws an
InvalidOperationException when two threads are using the same SqlCommand
instance at different times. As you can see below the application
synchronizes on the shared SqlCommand instances why thread synchronization is

I'm using VB.NET to query a SQL 2000 database through a view.
The query I am attempting is a SELECT COUNT query. When I run the query in
SQL Analyzer, it returns the count of around 3000 records in 1 second, but
when I run it in code with the sqlCommand object  in code, with the ...

I have a winform application. The backend database is MS Access.
I don't want to hardcode the database connectin string in my application.
What is the best practice to configure the database connection string in .Net
application ?

I am researching the best way to update SQL server with bunch on
information.
let's suppose that we have
one table in SQL database with 500 rows. load it in memory as Dataset and