private void appointmentsTableAdapter_RowUpdated(object sender, System.Data.OleDb.OleDbRowUpdatedEventArgs e)
{
if (e.Status == UpdateStatus.Continue && e.StatementType == StatementType.Insert)
{
int id = 0;
using (System.Data.OleDb.OleDbCommand cmd =
new System.Data.OleDb.OleDbCommand("SELECT @@IDENTITY", appointmentsTableAdapter.Connection)) {
id = (int)cmd.ExecuteScalar();
}
e.Row["ID"] = id;
}
}
/// <summary>
/// イベントで呼ばれる実際の処理：@@IDENTITYでオートナンバー型の列を取得する
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void Adapter_RowUpdated(object sender, System.Data.OleDb.OleDbRowUpdatedEventArgs e)
{
if (e.StatementType == System.Data.StatementType.Insert &&
e.Status == System.Data.UpdateStatus.Continue)
{
var cmd = new System.Data.OleDb.OleDbCommand("SELECT @@IDENTITY", null);
cmd.Connection = e.Command.Connection;
cmd.Transaction = e.Command.Transaction;
var result = cmd.ExecuteScalar();
if (result != null &&
result.GetType() != typeof(System.DBNull))
{
e.Row["ID"] = (int)result;
e.Row.AcceptChanges();
}
}
}
private void oleDbDataAdapter1_RowUpdated_1(object sender, System.Data.OleDb.OleDbRowUpdatedEventArgs e)
{
}
private void _adapter_RowUpdated(object sender, System.Data.OleDb.OleDbRowUpdatedEventArgs e)
{
AccessIDHelper.SetPrimaryKey(this.Transaction, e);
}
void SDAdapter_RowUpdated(object sender, System.Data.OleDb.OleDbRowUpdatedEventArgs e)
{
toolStripProgressBar.Value += 1;
toolStripMain.Update();
}
private void adpAlumnos_RowUpdated(object sender, System.Data.OleDb.OleDbRowUpdatedEventArgs e)
{
}
private void adpEncabezado_RowUpdated(object sender, System.Data.OleDb.OleDbRowUpdatedEventArgs e)
{
}
