Under ADO.NET and SQL 2000
I build form that edit data, and i use with wizard to create Update query.
What happen in this situation?:
I read record into DataSet. The user 1 change value an field A in the

I'm learning VB.NET and am trying to code a simple form to read and update an
Access Database.  I can connect to the database, read a row into a
dataset/table and bind it to textboxes on a form.  But I can't get any
changes to the textboxes to update the original Access Database. ...

Hi Newsgroup,
I have a really suspicious problem:
I want to write the data of a Dataset to a XML-File, wich should include
then schema of the data.

How can I create stored procedure with clause "where integer=ALL" that
would return all the values.
select * from tblA where integer = ALL
I  cannot use like in this procedure and because this is integer I

I have a datatable which is bound to a database table.
the table has a primary key on 1 field and i am using the machine
generated statements from the sql data adapter.
here is the scenario

I have a question to which I hope someone has the answer.  We have developed
an application that queries a database a great deal and speed is crucial.  We
do all database operations utilizing stored procedures and return the
information in parameters since there would be only one ...

I have been using OLEDB to pull excel tables into a dataset in dotnet.  
Problem is, I have new tables coming at me that have an extra row.  I am
hoping there is some way to tell Excel that the header row is in row 2, and
that the data starts in row 3.

I'm still having trouble getting the updates to work.  I read the row in from
the dataset  and bind it to a textbox.  When the user hits a Save button, I
have code to perform the update, but nothing gets Updated.  No errors, just
no update.

I'm using DataView.Sort to sort a dataset containing data with Norwegian
Special Characters. Even thou Thread.CurrentThread.CurrentCulture is
correctly set to Norwegian Bokmaal the Norwegian characters are sorted in
the wrong order.

Has anyone got experience in how to get foreign characters properly
out of an object with OracleXmlType type? In the Oracle database, the
foreign characters, e.g. Ä Ö Å from Scandinavian languages, can be
saved correctly. When using an OracleXmlType object to take XML data

DataSet is supposed to be an in-memory database. So is it possible to fire a query on it. I want to fire a "Select" query (with alises in it) and also a "Transform" (Crosstab) query. In the current scenario I am putting things in an Access table but for performance reasons want ...

I am afraid I am not understanding at all how OleDbParameters work (I am new
to SQL) ... the simple code below fails with E_ABORT:
   OleDbParameter p = catCMD.CreateParameter();
   p.ParameterName = "val2";

   In .NET 2, is there any way to batch multiple DataSet updates like the
ones that occur on a windows form editing a parent and a child table? This
means at least 4 calls to TableAdapter.Update plus multiple round trips to
the server while the TableAdapter traverses each row and

My task is a little more complicated than that because of my user
requirements.  In my app I have made the DataGrid read only because there is
concern that the users will inadvertently delete rows.  I need the Delete to
be a two-step process in which the user selects rows on the ...

this code below returns an int array (length=8) from the sql server 2K
proc. I have NO idea why... any suggestions?
----------------------------------------------------------------------------
Address a = address;