I have a Windows form with a number of Bound Controls.  When I want to add a new record I clear all the combo boxes and text boxes by setting the text properties to "". To add a new record to the dataset I use
Dim drNew As System.Data.DataRo
       drNew = Me.DsEstablishMaint1 ...

I don't know if anyone has ever experienced the same problems as I did, but
I would like to suggest a number of changes or at least directions of
re-engineering which, once implemented, will make ADO.NET faster, more
flexible and better than it was at all.

ds2.Tables("PLU").Rows(rowCount)("PLUID") = PLURef.Rows(rowCount2)("PLUID")
translated into english :
3   = 1900
but when i view the datatable...the original value of 3 is still being

Do you know what's wrong with the code below? I get an error: error in
method ~MoveNext: collection was modified. Enumeration operation may not
execute. It happens when I step through the 'Next'  of for-loop
Thanks in advance,

What would be a way to populate DataGrid with data from SQL table using DAAB
Thanks

I'm using WriteXmlSchema to create a schema from a dataset. The next step is to do a BULK INSERT into SQL SERVER 2000, but the XSD file needs the changes listed below to work correctly. Is there a better way to create a XSD for BULK INSERT? Or what is the best way to change and ...

I am adding a row to the datatable, and then I want to sort it, so I
put this into a dataview, and use the following code to sort it, but
it stays in the same order after I've done it.
datatable.rows.add(newrow)

   how can I execute a Sql Function with ado.net?
   The function name is "db.dbo.fn_get_max_date" and
it has not any parameter.
Regards,

I am only able to connect to an Act6.0 db with ODBC Connection (Foxpro DSN).
Is there a better way?

I can't seem to get my dataview configured properly.  I am using it on
a windows form to filter information from a datatable which is itself
populated from a dataset and ultimately, from a datasource (external
database).  The datatable populates fine, but the dataview keeps

Does anyone know a way to refresh the data shown in a dataview?
Without destroying and recreating it?
Thanks,
Mike Cooper

Can someone help an ado.net newbie.
I have and xmldoc something like this
<response>
<command ref="command1">

Using Access 2002 / .Net.
I need to update a database through dataadapter.update(dataset).
The problem is one of the tables had two foreign keys , linking to
autonumbers in its parents tables.

Hi there ;
I got the following problem, I hope you can help me out guys!
I need to display some records from a table, and I need to insert in every
row a checkbox, to select some of those records.

When using ADO to read Excel data the connection string parameter
"DataSource" points to the excel file. Is there any way to read data
from a file stream?
Thanks