110,533
社区成员
发帖
与我相关
我的任务
分享
public static bool Exec_NonQuery(string strSQL)
{
bool flag = false;
SqlConnection connection = new SqlConnection(Get_Database_Conn());
try
{
connection.Open();
}
catch(Exception ex1)
{
throw ex1;
return false;
}
//SqlTransaction transaction = null;
SqlCommand command;
try
{
//transaction = connection.BeginTransaction();
//command = new SqlCommand(strSQL, connection, transaction);
command = new SqlCommand(strSQL, connection);
command.ExecuteNonQuery();
//transaction.Commit();
flag = true;
}
catch (Exception ex2)
{
throw ex2;
//try
//{
// transaction.Rollback();
//}
//catch {}
flag = false;
}
finally
{
connection.Close();
}
return flag;
}
public static string Get_Database_Conn()
{
return ("Data Source=" + Database_IP + ";Database=" + Database_Name
+ ";User ID=" + Database_User + ";Password=" + Database_Password
+ ";Max Pool Size=10;Min Pool Size=1;pooling=true");
}