string sql = "update view1 set E_Name='@name' where E_ID=@id";
SqlParameter[] para =
{
new SqlParameter("@name",name),
new SqlParameter("@no",id)
};
if( database.ExecuteNonQuery(sql, para)>=0)
public static int ExecuteNonQuery(string sql,SqlParameter[] para)
{
if (co.State == ConnectionState.Closed)
{
co.Open();
}
SqlCommand com = new SqlCommand(sql);
com.Connection = co;
com.CommandText = sql;
com.Parameters.AddRange(para);
int i = com.ExecuteNonQuery();
return i;
if (co.State == ConnectionState.Open)
{
co.Close();
co.Dispose();
}
为什么会出现必须声明标量变量 "@id"