Question

ASP.NET 错误提示：必须声明标量变量“@cs”

具体代码如下：
protected void GridView1_RowCommand(object sender, GridViewCommandEventArgs e)
{
string crs = GridView1.DataKeys[Convert.ToInt32(e.CommandArgument)].Value.ToString().Trim();
if (e.CommandName == "xinxi")
{
string cons = @"Data Source=valan\sqlexpress;Initial Catalog=gongchengshijian3;Integrated Security=True;";
SqlConnection con = new SqlConnection(cons);
con.Open();
SqlCommand com = new SqlCommand();
com.Connection = con;
com.CommandType = CommandType.Text;
string sql = "select 信息编号,主题,发布人,发表日期 from xinxi where 课程编号=@cs";
SqlDataAdapter da = new SqlDataAdapter(sql, con);
new SqlParameter("@cs", crs);
DataSet ds = new DataSet();
da.Fill(ds);
GridView2.DataSource = ds.Tables[0];
GridView2.DataBind();
con.Close();

}
}

求大神指导该怎么改

Answer 1

没定义参数
SqlParameter Name= new SqlParameter("@cs", '这个值);
cmd.Parameters.Add(Name);