I'm running into a strange concurrency problem:
I have an outer loop of distinct invnum from table a_r; I have an inner loop
of table a_r2 that is filtered on 'invnum = out loop invnum'.  I calculate
and then want to delete, but I have the concurrency error, which I supposed

I've been using the following to fetch my keyvalues at runtime.  But I just
changed my base query to join into a couple of new tables so it's no longer
retreiving a valid key.
MyDa.MissingSchemaAction = MissingSchemaAction.AddWithKey;

How can I get the Worsheet name in my SELECT statement using ADO.NET
"SELECT * FROM [mysheet$]
I do not know what mysheet$ name is
Yama

I have a trigger like this (simplified to illustrate the problem):
--------
CREATE TRIGGER Test ON [dbo].[TestTable]
FOR INSERT, UPDATE, DELETE

How do you set up a create an xml schema  column element and define it as either an System.Object or as a System.Type in the xml designer?
I have tried anyType but it complains when previewing the dataset.  Any thoughts????

Hi Folk
Im trying to create a datatable but i keep encountering the following error message
An unhandled exception of type 'System.Data.SqlClient.SqlException' occurred in system.data.dl
Additional information: System error

It was suggested that I post this item here.  Sorry about the cross post
I am using a datagrid to display information from a table.  I have successfully been able to select items and make the values appear in different textboxes on the form.  I would like to be able to select a ...

I'm working with VS.NET 2003 and SQL Server 2000.
After having created a sqlDataAdapter and a sqlConnection by dragging
a database table from Server Explorer onto the form's design surface,
I then generate a dataset from the sqlDataAdapter...you know, the

I have a form that is bound to a table in my strongly-typed dataset. When I
create a new record, I am using the following code:
With Me.BindingContext(m_oDataSet.SecUser)
 .EndCurrentEdit()

I have a C# program that works one time and fails the next on my deployment
test system.  It does not fail on my development system.  The deployment
uses the installation procedure created by Visual Studio 2003.  The
deployment is installing the .NET Framework ver 1.1,  MSDE 2000, ...

SCENARIO
--------
I have a Win forms project (C#), two comboboxes databound to two
tables linked with a relation (parent child).  Selecting a value from

I am testing what happens with our updates when I delete a row after it's
been cached on the client in a Datatable.
I retrieve the record.  It sits in a DataRow inside a DataTable on the
client.

This is part of the code
DataTable y = new DataTable("newData");
int rowCount = destData.Tables[0].Rows.Count;
for (int i = (rowCount - 1);i >=0; i--)

I have previously worked with Access 2000 and SQL server 2000 and I am
comfortable using ADO in this way.
In a (probably vain) attempt to take things further I bought a copy of
VB.net standard edition with an eye to writing stand-alone applications with

i have created an sqldataadapter using a wizard and i can save it
using datagrid control but don't know how to save the data from
textbox. because i have a master detail form and the master form is
populated w/ textboxes while the detail form is populated w/ datagrid