SqlCommand cmd = new SqlCommand();
cmd.CommandText = "update login set name=@name,email=@email,sex=@sex,hobby=@hobby,direction=@direction where username=@uername";
cmd.Connection = con;
cmd.Parameters.Add(new SqlParameter("@name", TextBox1.Text));
cmd.Parameters.Add(new SqlParameter("@email", TextBox2.Text));
cmd.Parameters.Add(new SqlParameter("@sex", DropDownList1.Text));如何把条件值赋给username啊?????
条件值是在另一个页面产生的(变量),,,,session[username]
地址栏参数也行
这样的方法很多吧
楼主的结贴率
cmd.CommandText = "update login set name=@name,email=@email,sex=@sex,hobby=@hobby,direction=@direction where username=@uername";
cmd.Connection = con;
cmd.Parameters.Add(new SqlParameter("@name", TextBox1.Text));
cmd.Parameters.Add(new SqlParameter("@email", TextBox2.Text));
cmd.Parameters.Add(new SqlParameter("@sex", DropDownList1.Text));
cmd.Parameters.Add(new SqlParameter("@sex", session["useranme"].toString())); 加上这一句试试 SQL里面就不用改了