表shareRain,有snum、status两个字段。代码如下:
string sql = "update [CAWS600B].[dbo].[shareRain] set Status='0'";
SqlConnection sqlConnection = new SqlConnection(MyConn());
sqlConnection.Open();
SqlDataAdapter sqlDateAdapter = new SqlDataAdapter(sql, MyConn());
SqlCommandBuilder sqlCommandBuilder = new SqlCommandBuilder(sqlDateAdapter);
sqlConnection.Close();
想要的结果是将status字段内容全部更改为0,上面的代码哪里存在问题,运行不出错,但是表的内容没有变化。
string sql = "update [CAWS600B].[dbo].[shareRain] set Status='0'";
SqlConnection sqlConnection = new SqlConnection(MyConn());
sqlConnection.Open();
SqlDataAdapter sqlDateAdapter = new SqlDataAdapter(sql, MyConn());
SqlCommandBuilder sqlCommandBuilder = new SqlCommandBuilder(sqlDateAdapter);
sqlConnection.Close();
想要的结果是将status字段内容全部更改为0,上面的代码哪里存在问题,运行不出错,但是表的内容没有变化。
SqlConnection sqlConnection = new SqlConnection(MyConn());
sqlConnection.Open();
SqlCommand sqlCommand = sqlConnection.CreateCommand();
sqlCommand.CommandText = sql;
sqlCommand.ExecuteNonQuery();
sqlConnection.Close();
/// <summary>
/// 执行指定的SQL语句。(使用SqlCommand 类)
/// </summary>
public static bool RunSQL(string sql)
{
SqlConnection MyConn = new SqlConnection(ConnStr());
SqlCommand MyComm = MyConn.CreateCommand();
MyComm.CommandTimeout = 60;
try
{
MyConn.Open();
MyComm.CommandText = sql;
MyComm.ExecuteNonQuery();
return true;
}
catch
{
return false;
}
finally
{
MyComm.Dispose();
MyConn.Dispose();
}
}
表shareRain,有snum、status两个字段。你的这个MyConn()方法返回是数据库连接字符串嘛?
string sql = "update [CAWS600B].[dbo].[shareRain] set Status='0'";
SqlConnection sqlConnection = new SqlConnection(MyConn());
sqlConnection.Open();
SqlCommand cmd = new SqlCommand(sql,sqlConnection);
cmd.ExecuteNonQuery();
sqlConnection.Close();