获取文本框中的值
问题如下:
在页面的后台load事件中给文本框赋值了
然后我要对文本框中的值进行修改再保存,可是修改之后不能获取修改后文本框中的内容,程序调试的时候发现 保存的程序中还是load事件赋的值 没有变化
string no = "";
protected void Page_Load(object sender, EventArgs e)
{
DbHelper db = new DbHelper();
DbCommand cmd = db.GetSqlStringCommond("select top 1 * from companyinfo");
DbDataReader reader = db.ExecuteReader(cmd);
if (reader.Read())
{
cmpaddress.Text = reader["address"].ToString().Trim();
cmpcode.Text = reader["code"].ToString().Trim();
cmpcontactpeople.Text = reader["contactpeople"].ToString().Trim();
cmpemail.Text = reader["email"].ToString().Trim();
cmpfax.Text = reader["fax"].ToString().Trim();
cmpname.Text = reader["companyname"].ToString().Trim();
cmpphone.Text = reader["phone"].ToString().Trim();
cmpqyln.Text = reader["qiyelinian"].ToString().Trim().Replace("$", "\r\n");
cmptel.Text = reader["tel"].ToString();
cmpjianjie.Text = reader["jianjie"].ToString().Replace("$", "\r\n");
no = reader["infoid"].ToString().Trim();
}
else
{
MessageBox.Show(this, "用户名不存在!");
}
}
protected void btnAdd_Click(object sender, EventArgs e)
{
try
{
DbHelper db = new DbHelper();
DbCommand cmd = db.GetSqlStringCommond("update companyinfo set companyname=@cmpname,contactpeople=@cmpcontactpeople ,tel=@cmptel,"+
"phone=@cmpphone ,fax=@cmpfax,address=@cmpaddress,email=@cmpemail,code=@cmpcode,"+
"qiyelinian=@cmpqiyelinian,imgname=@cmpimgname,jianjie=@cmpjianjie" +
" where infoid=@id");
db.AddInParameter(cmd, "@cmpname", DbType.String, cmpname.Text.Trim());
db.AddInParameter(cmd, "@cmpcontactpeople", DbType.String, cmpcontactpeople.Text.Trim());
db.AddInParameter(cmd, "@cmptel", DbType.String, cmptel.Text.Trim());
db.AddInParameter(cmd, "@cmpphone", DbType.String, cmpphone.Text.Trim());
db.AddInParameter(cmd, "@cmpfax", DbType.String, cmpfax.Text.Trim());
db.AddInParameter(cmd, "@cmpaddress", DbType.String, cmpaddress.Text.Trim());
db.AddInParameter(cmd, "@cmpemail", DbType.String, cmpemail.Text.Trim());
db.AddInParameter(cmd, "@cmpcode", DbType.String, cmpcode.Text.Trim());
db.AddInParameter(cmd, "@cmpimgname", DbType.String, imgupload.FileName);
string qiyelinian = this.cmpqyln.Text.Trim().Replace("\r\n", "$");
string content = this.cmpjianjie.Text.Trim().Replace("\r\n", "$");
db.AddInParameter(cmd, "@cmpqiyelinian", DbType.String, qiyelinian);
db.AddInParameter(cmd, "@cmpjianjie", DbType.String, content);
db.AddInParameter(cmd, "@id", DbType.String, no);
if (db.ExecuteNonQuery(cmd) == 1)
{
MessageBox.Show(this, "成功修改");
}
else
{
MessageBox.Show(this, "修改失败,请重新修改!");
}
}
catch (Exception ee)
{
MessageBox.Show(this, ee.ToString());
}
}