从数据库中读去数据,然后将数据显示在TextBox中:
//从数据库中取出用户原始信息
SqlConnection mySqlConnection = new SqlConnection(System.Configuration.ConfigurationSettings.AppSettings["Msdsn"]);
SqlCommand mySqlCommand = mySqlConnection.CreateCommand();
mySqlCommand.CommandText = "SELECT * FROM Users WHERE UserName = @UserName";
mySqlCommand.Parameters.Add("@UserName", SqlDbType.VarChar, 50);
mySqlCommand.Parameters["@UserName"].Value = this.Session["UserName"].ToString();try
{
mySqlConnection.Open();
SqlDataReader mySqlDataReader = mySqlCommand.ExecuteReader();
if(mySqlDataReader.Read())
{
this.TB_Name.Text = mySqlDataReader["Name"].ToString();
this.RB_Sex2.Checked = !(bool)mySqlDataReader["Sex"];
this.TB_Birthday.Text = mySqlDataReader["Birthday"].ToString();
this.TB_Address.Text = mySqlDataReader["Address"].ToString();
this.TB_PostalCode.Text = mySqlDataReader["PostalCode"].ToString();
this.TB_Phone.Text = mySqlDataReader["Phone"].ToString();
this.TB_CardID.Text = mySqlDataReader["CardID"].ToString();
this.TB_Oicq.Text = mySqlDataReader["OICQ"].ToString();
this.TB_Email.Text = mySqlDataReader["Email"].ToString();
this.TB_HomePage.Text = mySqlDataReader["HomePage"].ToString();
this.TB_Memo.Text = mySqlDataReader["Memo"].ToString();
}
}
finally
{
mySqlConnection.Close();
}然后就修改数据库,在网页页面中填写数据后提交:
SqlConnection mySqlConnection = new SqlConnection(System.Configuration.ConfigurationSettings.AppSettings["Msdsn"]);
SqlCommand mySqlCommand = mySqlConnection.CreateCommand();
mySqlCommand.CommandText = "UPDATE Users SET Name = @Name, Sex = @Sex, Birthday = @Birthday, Address = @Address, PostalCode = @PostalCode, Phone = @Phone, CardID = @CardID, OICQ = @OICQ, Email = @Email, HomePage = @HomePage, Memo = @Memo WHERE UserName = @UserName";mySqlCommand.Parameters.Add("@Name", SqlDbType.VarChar, 50);
mySqlCommand.Parameters.Add("@Sex", SqlDbType.Bit);
mySqlCommand.Parameters.Add("@Birthday", SqlDbType.DateTime);
mySqlCommand.Parameters.Add("@Address", SqlDbType.VarChar, 50);
mySqlCommand.Parameters.Add("@PostalCode", SqlDbType.VarChar, 50);
mySqlCommand.Parameters.Add("@Phone", SqlDbType.VarChar, 50);
mySqlCommand.Parameters.Add("@CardID", SqlDbType.VarChar, 50);
mySqlCommand.Parameters.Add("@OICQ", SqlDbType.VarChar, 50);
mySqlCommand.Parameters.Add("@Email", SqlDbType.VarChar, 50);
mySqlCommand.Parameters.Add("@HomePage", SqlDbType.VarChar, 100);
mySqlCommand.Parameters.Add("@Memo", SqlDbType.VarChar, 255);
mySqlCommand.Parameters.Add("@UserName", SqlDbType.VarChar, 50);mySqlCommand.Parameters["@Name"].Value = this.TB_Name.Text;
mySqlCommand.Parameters["@Sex"].Value = this.RB_Sex1.Checked;
mySqlCommand.Parameters["@Birthday"].Value = this.TB_Birthday.Text;
mySqlCommand.Parameters["@Address"].Value = this.TB_Address.Text;
mySqlCommand.Parameters["@PostalCode"].Value = this.TB_PostalCode.Text;
mySqlCommand.Parameters["@Phone"].Value = this.TB_Phone.Text;
mySqlCommand.Parameters["@CardID"].Value = this.TB_CardID.Text;
mySqlCommand.Parameters["@OICQ"].Value = this.TB_Oicq.Text;
mySqlCommand.Parameters["@Email"].Value = this.TB_Email.Text;
mySqlCommand.Parameters["@HomePage"].Value = this.TB_HomePage.Text;
mySqlCommand.Parameters["@Memo"].Value = this.TB_Memo.Text;
mySqlCommand.Parameters["@UserName"].Value = this.Session["UserName"].ToString();try
{
mySqlConnection.Open();
mySqlCommand.ExecuteNonQuery();
}
finally
{
mySqlConnection.Close();
}这是文本框中的数据仍然是原来数据库中读取的数据,就是在提交过程中,文本框的数据有还原成原来的数据了
这是什么问题?
//从数据库中取出用户原始信息
SqlConnection mySqlConnection = new SqlConnection(System.Configuration.ConfigurationSettings.AppSettings["Msdsn"]);
SqlCommand mySqlCommand = mySqlConnection.CreateCommand();
mySqlCommand.CommandText = "SELECT * FROM Users WHERE UserName = @UserName";
mySqlCommand.Parameters.Add("@UserName", SqlDbType.VarChar, 50);
mySqlCommand.Parameters["@UserName"].Value = this.Session["UserName"].ToString();try
{
mySqlConnection.Open();
SqlDataReader mySqlDataReader = mySqlCommand.ExecuteReader();
if(mySqlDataReader.Read())
{
this.TB_Name.Text = mySqlDataReader["Name"].ToString();
this.RB_Sex2.Checked = !(bool)mySqlDataReader["Sex"];
this.TB_Birthday.Text = mySqlDataReader["Birthday"].ToString();
this.TB_Address.Text = mySqlDataReader["Address"].ToString();
this.TB_PostalCode.Text = mySqlDataReader["PostalCode"].ToString();
this.TB_Phone.Text = mySqlDataReader["Phone"].ToString();
this.TB_CardID.Text = mySqlDataReader["CardID"].ToString();
this.TB_Oicq.Text = mySqlDataReader["OICQ"].ToString();
this.TB_Email.Text = mySqlDataReader["Email"].ToString();
this.TB_HomePage.Text = mySqlDataReader["HomePage"].ToString();
this.TB_Memo.Text = mySqlDataReader["Memo"].ToString();
}
}
finally
{
mySqlConnection.Close();
}然后就修改数据库,在网页页面中填写数据后提交:
SqlConnection mySqlConnection = new SqlConnection(System.Configuration.ConfigurationSettings.AppSettings["Msdsn"]);
SqlCommand mySqlCommand = mySqlConnection.CreateCommand();
mySqlCommand.CommandText = "UPDATE Users SET Name = @Name, Sex = @Sex, Birthday = @Birthday, Address = @Address, PostalCode = @PostalCode, Phone = @Phone, CardID = @CardID, OICQ = @OICQ, Email = @Email, HomePage = @HomePage, Memo = @Memo WHERE UserName = @UserName";mySqlCommand.Parameters.Add("@Name", SqlDbType.VarChar, 50);
mySqlCommand.Parameters.Add("@Sex", SqlDbType.Bit);
mySqlCommand.Parameters.Add("@Birthday", SqlDbType.DateTime);
mySqlCommand.Parameters.Add("@Address", SqlDbType.VarChar, 50);
mySqlCommand.Parameters.Add("@PostalCode", SqlDbType.VarChar, 50);
mySqlCommand.Parameters.Add("@Phone", SqlDbType.VarChar, 50);
mySqlCommand.Parameters.Add("@CardID", SqlDbType.VarChar, 50);
mySqlCommand.Parameters.Add("@OICQ", SqlDbType.VarChar, 50);
mySqlCommand.Parameters.Add("@Email", SqlDbType.VarChar, 50);
mySqlCommand.Parameters.Add("@HomePage", SqlDbType.VarChar, 100);
mySqlCommand.Parameters.Add("@Memo", SqlDbType.VarChar, 255);
mySqlCommand.Parameters.Add("@UserName", SqlDbType.VarChar, 50);mySqlCommand.Parameters["@Name"].Value = this.TB_Name.Text;
mySqlCommand.Parameters["@Sex"].Value = this.RB_Sex1.Checked;
mySqlCommand.Parameters["@Birthday"].Value = this.TB_Birthday.Text;
mySqlCommand.Parameters["@Address"].Value = this.TB_Address.Text;
mySqlCommand.Parameters["@PostalCode"].Value = this.TB_PostalCode.Text;
mySqlCommand.Parameters["@Phone"].Value = this.TB_Phone.Text;
mySqlCommand.Parameters["@CardID"].Value = this.TB_CardID.Text;
mySqlCommand.Parameters["@OICQ"].Value = this.TB_Oicq.Text;
mySqlCommand.Parameters["@Email"].Value = this.TB_Email.Text;
mySqlCommand.Parameters["@HomePage"].Value = this.TB_HomePage.Text;
mySqlCommand.Parameters["@Memo"].Value = this.TB_Memo.Text;
mySqlCommand.Parameters["@UserName"].Value = this.Session["UserName"].ToString();try
{
mySqlConnection.Open();
mySqlCommand.ExecuteNonQuery();
}
finally
{
mySqlConnection.Close();
}这是文本框中的数据仍然是原来数据库中读取的数据,就是在提交过程中,文本框的数据有还原成原来的数据了
这是什么问题?
解决方案 »
- 为asp.net网站添加项目
- ADO.NET Entity Data Model中如何对同表父子关联进行映射
- wml问题
- datagrid的问题
- SharePoint Portal Server 2003 创建门户网站,失败了,这是日志,帮我看看,这是什么原因
- 一个关于时间的问题,急用!在线等!~~
- authentication mode="Forms" 刚接触.NET程序,提示这行错误,是怎么回事啊。
- 请高手帮忙啊!
- 请问一个让我迷惑的问题!
- 请指点如何对datatable排序(不用dataview)
- 请问:..NET Mobile开发与WAP开发二者之间有什么不同??
- 还是datagrid的问题,如何实现DataGrid删除确认及Item颜色交替?
if not ispostback then
......取出数据
end if
if (!Page.IsPostBack)
{
//..这里放你上面取出数据的代码,默然你没有在page_load加 判断ispostback
}这样你就会更改得了