textbox已经接收其他页面传来的值,怎样重新接受输入的值呢
如题,我是从其他网页传来数据,然后进行查询然后全部显示出来,但是现在的问题就是怎么样改变现在textbox中的值为文本框中输入的值呢,求大神指教
代码如下:
string a =Request.QueryString["no"].ToString();
TextBox1.Text = a;
string str = ConfigurationManager.ConnectionStrings["ApplicationServices"].ConnectionString;
SqlConnection Conn = new SqlConnection(str);
Conn.Open();
SqlCommand cmd = new SqlCommand();
cmd.Connection = Conn;
cmd.CommandText = "select * from Building where Building_Name='" + this.TextBox1.Text + "'";
SqlDataReader dr = cmd.ExecuteReader();
if (dr.Read())
{
this.TextBox2.Text = dr["Building_Introduction"].ToString();
this.TextBox3.Text = dr["Building_ID"].ToString();
}
dr.Close();
Conn.Close();
然后是修改:
string sms_sqlstr = "update Building set Building_Name='" + a + "',Building_Introduction='" + b + "' where Building_ID='" + TextBox3.Text + "'";
SqlCommand sms_comm = new SqlCommand(sms_sqlstr, conn);
sms_comm.Connection.Open();
try
{
sms_comm.ExecuteNonQuery();
Response.Write("<script>alert(\"修改成功!\");</script>");
TextBox1.Text = "";
TextBox2.Text = "";
}
catch (SqlException)
{
Response.Write("<script>alert(\"修改失败!\");</script>");
}
sms_comm.Connection.Close();