[System.Diagnostics.DebuggerNonUserCodeAttribute()]
[System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")]
[System.ComponentModel.DataObjectMethodAttribute(System.ComponentModel.DataObjectMethodType.Delete, false)]
public virtual int DeleteQuery(int 编号) {
System.Data.OleDb.OleDbCommand command = this.CommandCollection[1];
command.Parameters[0].Value = ((int)(编号));
System.Data.ConnectionState previousConnectionState = command.Connection.State;
if (((command.Connection.State & System.Data.ConnectionState.Open)
!= System.Data.ConnectionState.Open)) {
command.Connection.Open();
s = command.Connection.State.ToString();
}
int returnValue;
try {
returnValue = command.ExecuteNonQuery();
}
finally {
if ((previousConnectionState == System.Data.ConnectionState.Closed)) {
command.Connection.Close();
}
}
return returnValue;
} private void button1_Click(object sender, EventArgs e)
{
WindowsApplication1.db1DataSetTableAdapters.表1TableAdapter adapter = new WindowsApplication1.db1DataSetTableAdapters.表1TableAdapter();
WindowsApplication1.db1DataSet date=new WindowsApplication1.db1DataSet();
adapter.DeleteQuery(1);
}执行了 adapter.DeleteQuery(1); 并没有把数据库中编号=1的行删除,这是为什么?
[System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")]
[System.ComponentModel.DataObjectMethodAttribute(System.ComponentModel.DataObjectMethodType.Delete, false)]
public virtual int DeleteQuery(int 编号) {
System.Data.OleDb.OleDbCommand command = this.CommandCollection[1];
command.Parameters[0].Value = ((int)(编号));
System.Data.ConnectionState previousConnectionState = command.Connection.State;
if (((command.Connection.State & System.Data.ConnectionState.Open)
!= System.Data.ConnectionState.Open)) {
command.Connection.Open();
s = command.Connection.State.ToString();
}
int returnValue;
try {
returnValue = command.ExecuteNonQuery();
}
finally {
if ((previousConnectionState == System.Data.ConnectionState.Closed)) {
command.Connection.Close();
}
}
return returnValue;
} private void button1_Click(object sender, EventArgs e)
{
WindowsApplication1.db1DataSetTableAdapters.表1TableAdapter adapter = new WindowsApplication1.db1DataSetTableAdapters.表1TableAdapter();
WindowsApplication1.db1DataSet date=new WindowsApplication1.db1DataSet();
adapter.DeleteQuery(1);
}执行了 adapter.DeleteQuery(1); 并没有把数据库中编号=1的行删除,这是为什么?
public bool DeleteT(int ID)
{
int rowsAffected = Adapter.Delete(ID);
return rowsAffected == 1;
}