}
command1.ExecuteNonQuery();
command1.Dispose();
}
else
{
this.m_objCommand.CommandText = strSQL;
this.m_objCommand.ExecuteNonQuery();
}
} public int FillDataSet(ref DataSet objDataSet, string strSQL)
{
OleDbCommand command1 = new OleDbCommand(strSQL, this.m_objConn);
if (this.m_Timeout >= 30)
{
command1.CommandTimeout = this.m_Timeout;
}
OleDbDataAdapter adapter1 = new OleDbDataAdapter(command1);
int num1 = adapter1.Fill(objDataSet);
command1.Dispose();
adapter1.Dispose();
return num1;
} public int FillDataSet(ref DataSet objDataSet, string strSQL, string strTable)
{
OleDbCommand command1 = new OleDbCommand(strSQL, this.m_objConn);
if (this.m_Timeout >= 30)
{
command1.CommandTimeout = this.m_Timeout;
}
OleDbDataAdapter adapter1 = new OleDbDataAdapter(command1);
int num1 = adapter1.Fill(objDataSet, strTable);
command1.Dispose();
adapter1.Dispose();
return num1;
} ~CDBConn()
{
} public bool Lock(string[] strArrTableName)
{
return true;
// return this.m_objSync.Lock(strArrTableName);
}
public void Open()
{
if (this.m_objConn.State != ConnectionState.Open)
{
this.m_objConn.Open();
}
}
public void Rollback()
{
if (this.m_bIsInTransaction)
{
this.m_objTransaction.Rollback();
this.m_bIsInTransaction = false;
this.m_objCommand.Dispose();
}
} public void Update(string strSelectSQL, DataSet objDataSet)
{
OleDbDataAdapter adapter1;
OleDbCommandBuilder builder1;
if (!this.m_bIsInTransaction)
{
OleDbCommand command1 = new OleDbCommand(strSelectSQL, this.m_objConn);
if (this.m_Timeout >= 30)
{
command1.CommandTimeout = this.m_Timeout;
}
adapter1 = new OleDbDataAdapter(command1);
builder1 = new OleDbCommandBuilder(adapter1);
adapter1.InsertCommand = builder1.GetInsertCommand();
adapter1.DeleteCommand = builder1.GetDeleteCommand();
adapter1.UpdateCommand = builder1.GetUpdateCommand();
adapter1.Update(objDataSet);
builder1.Dispose();
command1.Dispose();
adapter1.Dispose();
}
else
{
adapter1 = new OleDbDataAdapter(this.m_objCommand);
builder1 = new OleDbCommandBuilder(adapter1);
adapter1.InsertCommand = builder1.GetInsertCommand();
adapter1.DeleteCommand = builder1.GetDeleteCommand();
adapter1.UpdateCommand = builder1.GetUpdateCommand();
adapter1.Update(objDataSet);
builder1.Dispose();
adapter1.Dispose();
}
}
// Properties
public ConnectionState State
{
get
{
return this.m_objConn.State;
}
}
public int Timeout
{
get
{
return this.m_Timeout;
}
set
{
if (value < 1)
{
this.m_Timeout = 1;
}
else
{
this.m_Timeout = value;
}
}
}
// Fields
private bool m_bIsInTransaction;
private OleDbCommand m_objCommand;
private OleDbConnection m_objConn;
private OleDbTransaction m_objTransaction;
private int m_Timeout;
}
}
-----------------------------------------------------------------------
欢迎交流.net开发经验.
qq: 32660346
msn: njbaige@hotmail.com
Mial:njbaige@126.com 原著文章，如果有转载请告知，谢谢。
大家有好的文章可以发邮件给我，互相学习，共同进步!
-----------------------------------------------------------------------
上一页 [1] [2] | 
注：本站部分文章源于互联网，版权归原作者所有！如有侵权，请原作者与本站联系，本站将立即删除！ 本站文章除特别注明外均可转载，但需注明出处！ [MinTao学以致用网] 