string
sCon;
sCon = System.Configuration.ConfigurationManager.ConnectionStrings[ " access " ].ConnectionString;
con = new OleDbConnection(sCon);
con.Open();
int i = - 1 ;
OleDbCommand cmd = con.CreateCommand();
OleDbTransaction tr = con.BeginTransaction();
cmd.Transaction = tr;
cmd.CommandText = …………;
try
{
i = cmd.ExecuteNonQuery();
if (i > 0)
{
cmd.CommandText = @"select @@identity";
i = int.Parse(cmd.ExecuteScalar().ToString());
}
tr.Commit();
}
catch (Exception e)
{
MessageBox.Show(e.Message);
}
this .Close();
return i;
sCon = System.Configuration.ConfigurationManager.ConnectionStrings[ " access " ].ConnectionString;
con = new OleDbConnection(sCon);
con.Open();
int i = - 1 ;
OleDbCommand cmd = con.CreateCommand();
OleDbTransaction tr = con.BeginTransaction();
cmd.Transaction = tr;
cmd.CommandText = …………;
try
{
i = cmd.ExecuteNonQuery();
if (i > 0)
{
cmd.CommandText = @"select @@identity";
i = int.Parse(cmd.ExecuteScalar().ToString());
}
tr.Commit();
}
catch (Exception e)
{
MessageBox.Show(e.Message);
}
this .Close();
return i;