After user enters a row of data into a DataGrid (.net 1.1), how to auto-update the actual database?

[sherifffruitfly]

Hi all,

I've got a form with a datagrid defined & presented to the user at
runtime (code at the bottom.) With this, the user can happily enter
all the data she likes. After a row of data is entered in the
datagrid, and the datagrid is about to start a new row for the user,
I'd like an UpdateDatabase( DataRow rowJustEntered) to be called.

I suppose some kind of define-and-subscribe-to-some-event has to take
place, but that's precisely the sort of thing I don't understand so
well.

How can I do this? I'm imagining the database update routine to be
centered around an InsertCommand.E xecuteNonQuery( ) call.

Thanks for any help,

cdj

=============== ===========

//manualForm is a Form with a DataGrid on it,
//and has already been instantiated.
DataSet manualDataSet = new DataSet();
manualDataSet.T ables.Add("tabl e");
manualForm.data Grid.SetDataBin ding(manualData Set, "table");
manualForm.Widt h = 300;
manualForm.Star tPosition = FormStartPositi on.CenterScreen ;

DataTable theTable = manualDataSet.T ables["table"];

DataColumn colIndex = new DataColumn("ind ex",
System.Type.Get Type("System.In t32"));
DataColumn colDate = new DataColumn("dat e",
System.Type.Get Type("System.Da teTime"));
DataColumn colData = new DataColumn("dat a",
System.Type.Get Type("System.Do uble"));

theTable.Column s.Add(colIndex) ;
theTable.Column s.Add(colDate);
theTable.Column s.Add(colData);

colIndex.AllowD BNull = false;
colDate.AllowDB Null = false;
colData.AllowDB Null = false;

DataColumn[] keyCols = {colIndex, colDate};
theTable.Primar yKey = keyCols;

manualForm.data Grid.ColumnHead ersVisible = true;

manualForm.Show ();

[sherifffruitfly]

On Jan 30, 2:54 pm, "sherifffruitfl y" <sherifffruit.. [e-mail]>
wrote:

Hi all,

I've got a form with a datagrid defined & presented to the user at
runtime (code at the bottom.) With this, the user can happily enter
all the data she likes. After a row of data is entered in the
datagrid, and the datagrid is about to start a new row for the user,
I'd like an UpdateDatabase( DataRow rowJustEntered) to be called.

I suppose some kind of define-and-subscribe-to-some-event has to take
place, but that's precisely the sort of thing I don't understand so
well.

Nevermind. lol! Woohoo! Figured one out on my own!

manualDataSet.T ables["table"].RowChanging += new
DataRowChangeEv entHandler(Upda teManual);