public bool SQLExecute(string sql)//传入命令语句字符串
{
int r = 0;
try
{
string ConnectionString = "数据库连接字符串";
SqlConnection myConn1 = new SqlConnection(ConnectionString);
myConn1.Open();
SqlCommand cmd1 = new SqlCommand();
cmd1.Connection = myConn1;
cmd1.CommandText = sql;
if (cmd1.ExecuteNonQuery() >= 1)
r = 1;
cmd1.Connection.Close();
myConn1.Close();
if (r == 1)
return true;
else
return false;
}
catch
{
return false;
}
}