Private Boolean dbupdate ()
{
String strSQL = "Select Productsspecid,productsspec,productsspecunit,productsid from Tbl_product_detail_master";
System.Data.DataTable dtupdate = new System.Data.DataTable ();
Dtupdate = This.dbconn (strSQL);
DtUpdate.Rows.Clear ();
System.Data.DataTable dtshow = new System.Data.DataTable ();
Dtshow = (DataTable) This.bindSource.DataSource;
Dtshow = (System.Data.DataTable) This.dgselect.DataSource;
int p1 = DtShow.Rows.Count;
//try
//{
for (int i = 0; i < DtShow.Rows.Count; i++)
{
DataRowState rowstate=new DataRowState ();
Rowstate=dtshow.rows[i]. RowState;
if (rowstate==datarowstate.added | | rowstate==datarowstate.detached | | rowstate==datarowstate.modified)
{
if (this.dgselect["Del", I). value.tostring () = = "1")
{
Dtshow.rows[i]. Delete ();
}
}
}
for (int i = 0; i < DtShow.Rows.Count; i++)
{
Dtupdate.importrow (Dtshow.rows[i]);
}
int num = DtUpdate.Rows.Count;
Try
{
This.conn.Open ();
trans = This.conn.BeginTransaction ();
Mysqlcommandbuilder Commandbuiler;
Commandbuiler = new Mysqlcommandbuilder (this.adapter);
This.adapter.Update (dtupdate);
trans.commit ();
This.conn.Close ( );
}
catch (Exception ex)
{
MessageBox.Show (ex. Message.tostring ());
Trans. Rollback ();
return false;
}
Dtupdate.acceptchanges ();
return true;
}