How to get get the last inserted key value from DataTable using C#

[rodrigo]

How to get get the last inserted key (value NOT column) in a specific
dataTable dt right after dt.Rows.InsertAt according to code and schema
below. The key is a autoincrement column.

foreach (MyContainer item in al)


{


dr = dt.NewRow();


dr["item_id"] = item.item_id;


dr["description"] = item.description;


dr["price"] = item.price;


dr["qty"] = item.qty;


// INSERTS ROW in DataTable


dt.Rows.InsertAt(dr,Convert.ToInt32(RowIndex.Text)-1);


//GET KEY RIGHT HERE





}





The schema :


private DataTable DataGrid_GetColumnsSchema()


{


DataTable dtquote = new DataTable("quote");


DataColumn dc = new DataColumn();


dc = new DataColumn("key", System.Type.GetType("System.Int32"));


dc.AutoIncrement=true;


dc.AutoIncrementSeed=1;


dtquote.Columns.Add(dc);


dc = new DataColumn("item_id",
System.Type.GetType("System.String"));


dtquote.Columns.Add(dc);


dc = new DataColumn("description",
System.Type.GetType("System.String"));


dtquote.Columns.Add(dc);





dc = new DataColumn("price",
System.Type.GetType("System.Decimal"));


dtquote.Columns.Add(dc);





dc = new DataColumn("qty", System.Type.GetType("System.Int32"));


dtquote.Columns.Add(dc);





dc = new DataColumn("extended_price",
System.Type.GetType("System.Decimal"));


dtquote.Columns.Add(dc);





dc = new DataColumn("sortorder",
System.Type.GetType("System.Int32"));


dtquote.Columns.Add(dc);





DataColumn[] keys = new DataColumn[1];


keys[0] = dtquote.Columns[0];


dtquote.PrimaryKey = keys;





return dtquote;


}







Thank you Very much

Rod