ASP.NET页面跳转和传值问题，更改数据库~

最新推荐文章于 2019-07-18 08:01:37 发布

笑到全世界都憔悴

最新推荐文章于 2019-07-18 08:01:37 发布

阅读量619

点赞数

本文链接：https://blog.csdn.net/ling1045535102/article/details/23547161

版权

传值到更新页面代码：

if (!IsPostBack)
{
int pid = Convert.ToInt32(Request.QueryString["ProductID"]);
int cid = 0;
string connStr = System.Configuration.ConfigurationManager.ConnectionStrings["stuConnstr"].ToString();
using (SqlConnection conn = new SqlConnection(connStr))
{
conn.Open();
string str = string.Format("select ProductID,ProductName,Quentity,Price,Picture,Memo,CatID from Product where ProductID={0}", pid);
SqlCommand comm = new SqlCommand(str, conn);
SqlDataReader dr = comm.ExecuteReader();
while (dr.Read())
{
TextBox1.Text = dr[0].ToString();
TextBox2.Text = dr[1].ToString();
TextBox3.Text = dr[2].ToString();
TextBox4.Text = dr[3].ToString();
TextBox6.Text = dr[4].ToString();
TextBox5.Text = dr[5].ToString();
cid = Convert.ToInt32(dr[6]);
}
dr.Close();
}
using (SqlConnection conn = new SqlConnection(connStr))
{
conn.Open();
string str = string.Format("select CatName from Category where CatID={0}", cid);
SqlCommand comm = new SqlCommand(str, conn);
SqlDataReader dr = comm.ExecuteReader();
while (dr.Read())
{
DropDownList1.Text = dr[0].ToString();
}
dr.Close();
}
//产品所有种类
using (SqlConnection conn = new SqlConnection(connStr))
{
conn.Open();
string str = string.Format("select CatName from Category");
SqlCommand comm = new SqlCommand(str, conn);
SqlDataReader dr = comm.ExecuteReader();
while (dr.Read())
{
DropDownList1.Items.Add(dr[0].ToString());
}
dr.Close();
}

}