I am loading the Dataset from one connection, do a few changes to a few rows
and want to insert all of those rows into another table in another
connection. the problem is that the primarily loaded rows have rowstate
unchanged, the ones that get changed have state changed but non of ...

I have a date field in a Dataset.  I need to change the
date field for display purposes so I would like to loop
through the dataset and modify the field before I bind it
to a grid.  Here is the code I have so far:

how can I get a value from a parent table to show up in a textfield (and be
updatable) based on the corresponding foreign key in the child table. The
two tables have a DataRelation object between them made by the designer i
Visual Studio (so it should be correctly set up)?

How does one convert a datatable to a sqlreader? We have a generic backend
that returns datasets or datatables. For sake of brevity assume I can't
change the backend to return a reader. Is there an easy way to do this?
Regards,

I am just trying to load a sql image field into a .Net image variable.
Suggestions?
Dim Im as Image
Im = cType(SqlDataReader.GetSqlBinary(0), image)   'does not work

i am a total newbie if it comes to .NET and all this.
therefore i have a guestion - i installed visual studio and according
to the manual i should have "data tab" in the toolbox.
i installed SDK and Framework.

Has anyone try to use NextResult method of DataReader for retrieving
multiple sql statements in one query?
Besides this method works for SQL Server, I'm using MS Access as database,
seems this method doesn't work, am I right that Access database do not

   I get a query from out side of my program. then I have to execute
and create an xml file. To put in xml file I need to know the table
name.
I am able to get field names and field types, values but how to get

What is the best way (regarding the performance) to upload file lines to a table in DB
Running SP for each line or smth else..
Thanks

       Dim sqlcmd1 As New SqlClient.SqlCommand()
       Dim sqlcon1 As New SqlClient.SqlConnection()
       Dim ds1 As New DataSet()
       Dim da1 As New SqlClient.SqlDataAdapter()

I need to use a dataset without binding to a text box. i need to move value
from dataset to textbox manually. does anyone have any sample for this.
Thanks and regards
atif

I have two grids on a form.  Contacts and Notes.  For
each contact there can be many notes.
When I click on a contact (which is bound to the contact
table) I want to fill the notes grid and I use the

I'm checking whether an exception is a DBConcurrencyException successfully but inelegantly in the code snippet below
I tried to capture the hresult property and compare that way, but ex.hresult says it is not accessible because it is a protected property.  Is there a more elegant ...

Update(DataTable) fails with HasErrors set to true.
This is due that some columns have DBNull value.
But those columns are defined as NULL (SQL Server).
Is it a dotnet bug or null values are not allowed?

I am converting dataset data's to XML using OutXml property...
I am getting xml. But null value columns are not populated with empty node
I want those columns with Empty Node.
How to populate that??