如何给where赋值

[rondsny]

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]

[fengyunshier]

session 和cookies都可以啊，
地址栏参数也行
这样的方法很多吧

[Dream_Hunter_]

cmd.CommandText = "update login set name=@name,email=@email,sex=@sex,hobby=@hobby,direction=@direction where username='"+UserName+"'";

[Dream_Hunter_]

cmd.CommandText = "update login set name=@name,email=@email,sex=@sex,hobby=@hobby,direction=@direction where username='"+session[username].ToString()+"'";
楼主的结贴率。。。

[Ilovehero]

cmd.Parameters.Add(new SqlParameter("@username", session[username]));

[戒烟戒酒戒编程]

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));
cmd.Parameters.Add(new SqlParameter("@sex", session["useranme"].toString()));

加上这一句试试 SQL里面就不用改了

[lihongxian]

[Quote=引用 4 楼 ilovehero 的回复:]
cmd.Parameters.Add(new SqlParameter("@username", session[username]));
[/Quote]
这个可以

[telent]

你的函数没参数？

[qawszx]

cmd.CommandText = "update login set name=@name,email=@email,sex=@sex,hobby=@hobby,direction=@direction where ltrim(rtrim(username))='"+session[username].ToString().Trim()+"'";

[人间太皮]

cmd.Parameters.Add(new SqlParameter("@userName", session["userName"].ToString()));

[hnjhjzyyxgs]

cmd.Parameters.Add(new SqlParameter("@sex", session["useranme"].toString()));