一个c#问题

来源：百度知道 编辑：UC知道 时间：2024/05/26 08:18:03
String sqlstring = "update Member set MemberDj=MemberDj+1 where id=" + mid;
SqlConnection conn = new SqlConnection();
conn.ConnectionString = "Server=(local);DataBase=CarPrice;User Id=sa;PWD=123456";
SqlCommand cmd = new SqlCommand(sqlstring, conn);
要让它执行 应该怎么写

Conn.Open()
cmd.ExecuteNonQuery();

cmd.ExecuteNonQuery();
这样就行了
try{
String sqlstring = "update Member set MemberDj=MemberDj+1 where id=" + mid;
SqlConnection conn = new SqlConnection();
conn.ConnectionString = "Server=(local);DataBase=CarPrice;User Id=sa;PWD=123456";
con.Open();
SqlCommand cmd = new SqlCommand(sqlstring, conn);
cmd.ExecuteNonQuery();
}
catch(Exception ex)
{
throw new Exception (ex.ToString());
}
finally
{
con.Close();
}

try{
String sqlstring = "update Member set MemberDj=MemberDj+1 where id=" + mid;
SqlConnection conn = new SqlConnection();
conn.ConnectionString = "Server=(local);DataBase=CarPrice;User Id=sa;PWD=123456";
SqlCommand cmd = new SqlCommand(sqlstring, conn);
conn.open();//打开连接
int result=cmd.ExecuteNonQuery();//执行SQL语句.并返回影响行数
}catch{
//处理异常
}finally{
conn.