关于textbox控件内容更新的问题。
我想用两个textbox来显示出标题和内容,然后在这两个textbox上进行编辑,编辑完了,点一个按钮,把更新过的内容写到数据库里去,但是我的这种做法没有达到预想的效果,大哥们来帮忙解决一下。
[code=C]
protected void Page_Load(object sender, EventArgs e)
{
string constr = ConfigurationManager.ConnectionStrings["WHConn"].ConnectionString;
SqlConnection conn = new SqlConnection(constr);
conn.Open();
//根据地址栏从数据库里读出相关的数据
string comstr = "select * from news where id ='" +Request.QueryString["id"]+"'";
DataSet ds = new DataSet();
SqlDataAdapter sda = new SqlDataAdapter(comstr , conn);
sda.Fill(ds,"news");
DataRow dr = ds.Tables["news"].Rows[0];
TextBox1.Text = dr["title"].ToString();
TextBox2.Text = dr["content"].ToString();
conn.Close();
}
protected void Button1_Click(object sender, EventArgs e)
{
string constr = ConfigurationManager.ConnectionStrings["WHConn"].ConnectionString;
SqlConnection conn = new SqlConnection(constr);
conn.Open();
string upstr = " update news set title = '" + TextBox1.Text.ToString().Trim() + "',content='" + TextBox2.Text.ToString().Trim() + "' where id = '" + Request.QueryString["id"] + "'";
SqlCommand comm = new SqlCommand(upstr,conn);
comm.ExecuteNonQuery();
Response.Redirect("manage_new.aspx");
}
[/code]