Is the DataReader only for SQLServer or can it be used with ODBC? If so, is
anyone aware of a sample out there?

I hava a typed dataset with 2 tables and a relation (master/detail).
I have an dataadapter to fill the master table (with a select and a
parameter) and now I want fill the second table with another dataadapter,
but I don't know how I have to define the select sentence to populate it

I want to pass a few thousand records to a SQLce database and then insert them in a table
Seems like the fastest way to do it (sql server replication not an option) is to pass a recordset that has all the records marked as DataRowState.Added, then use a dataadapter.update on the ...

I have one dataset populated with data
When I am using GetXML() method of this dataset, I am getting the XML representation o
the data. But, if a database field has Null value, then that node is not occuring in th
XML string

I want to know how it work in ADO.NET when a DEADLOCK occur and a
victim is choosen?
Is an exception raised?
Thank's

I have a DataSet with lots of data in it,
there is no database just the DataSet.
In the DataTable contained by the DataSet
there is a field Category. I would like to get the different Categories

Salut
J'ai ? peu pr?s fini le site... l'essentiel fonctionne... vous pouvez le
mettre en fen?tre dans le fond d'?cran de windows... c'est tr?s pratique
vous verrez...

H
I have the following code
sqlConnection1.Open()
System.Data.SqlClient.SqlCommand cmd = new System.Data.SqlClient.SqlCommand("[SOMEUSER].[PAK_TEST.P_OPEN]", sqlConnection1)

I would like to add a backup function in my winform app.
I use MSDE.
My idea was to :
   Detach the database

I am using vb.net and want to insert data from a .csv file into a table. I
am looking everywhere but am coming up empty. Can someone be so kind as to
post some sample code for me?
Thank you.

Hi to all
How can I make a ComboBox readonly ?
Enabled = false and DropDownStyle = DropDwnList
are not solutions for me.

I have DataSet with two DataTable and DataRelation between them.
I have two DataGrids with master / detail style and additional textbox which
are bind to detail table.
ds.Tables.Add(tableCompany);

I created a new command object passing the connection and the
transaction of the existing transaction. Then I call ExecuteNonQuery.
Instead of using the same connection it opens up a new connection
causing a deadlock as both are trying to use the same resource.

I have wrote a stored proc (Sproc) to update one of my sqlserver tables. This is what the query looks like
ALTER PROCEDURE dbo.UpdMea
(@NewName nvarchar(50)
@NewCost Money

Could anyone help me with the following "common" chalenge?
I have 2 simple tables. Customers and Zipcodes.
Customer:
CustomerID, CustomerNr, CustomerName, ZipID