protected void BT1_Click(object sender, EventArgs e)
{
SqlConnection cn = new SqlConnection("server=JIALIA;uid=sa;pwd=sa;database=JR_WebDatebase");
string tet = Textbox1.Text.ToString();
string strSQL = "Select * From Orderform Where [市名]=@tet";
SqlCommand cmd = new SqlCommand(strSQL, cn);
cn.Open();
GridView2.DataSource = cmd.ExecuteReader();
GridView2.DataBind();
Textbox1.Text = "";
cn.Close();
}asp.net在编译的时候没有问题在的运行这个Button的时候网页返回"必须声明变量 '@tet'"的一个错误。请达人指点一下。
{
SqlConnection cn = new SqlConnection("server=JIALIA;uid=sa;pwd=sa;database=JR_WebDatebase");
string tet = Textbox1.Text.ToString();
string strSQL = "Select * From Orderform Where [市名]=@tet";
SqlCommand cmd = new SqlCommand(strSQL, cn);
cn.Open();
GridView2.DataSource = cmd.ExecuteReader();
GridView2.DataBind();
Textbox1.Text = "";
cn.Close();
}asp.net在编译的时候没有问题在的运行这个Button的时候网页返回"必须声明变量 '@tet'"的一个错误。请达人指点一下。
SqlCommand cmd = new SqlCommand(strSQL, cn);
//添加如下:
dbCmd.Parameters.Add("@tet", OleDbType.VarChar);
dbCmd.Parameters["@tet"].Value = tet;或者改成这样:
string strSQL = String.Format("Select * From Orderform Where [市名]='{0}'",tet);
SqlCommand cmd = new SqlCommand(strSQL, cn);
{
SqlConnection cn = new SqlConnection("server=JIALIA;uid=sa;pwd=sa;database=JR_WebDatebase");
string tet = Textbox1.Text.ToString();
string strSQL = "Select * From Orderform Where [市名]=@tet";
SqlCommand cmd = new SqlCommand(strSQL, cn);
cmd.Parameters.Add("@tet", OleDbType.VarChar).Value = "你打算赋的值";
cn.Open();
GridView2.DataSource = cmd.ExecuteReader();
GridView2.DataBind();
Textbox1.Text = "";
cn.Close();
}