/// <summary>
/// 執行sql語句(事務)
/// </summary>
///
public bool cmdsql(string[] str)
{
getoconn();
mytrans =oconn.begintransaction();
ocmd=new oledbcommand();
ocmd.connection=oconn;
ocmd.transaction=mytrans;
try
{
for(int i=0;i<str.length;i++)
{
ocmd.commandtext=str[i];
ocmd.executenonquery();
}
mytrans.commit();
closeoconn();
return true;
}
catch
{
mytrans.rollback();
return false;
}
}
新聞熱點
疑難解答
圖片精選