刚进入asp.net,有个很菜的问题想请请各位ggjjm帮忙,我用Session("username")从A页面传递一个值到B页面,想用这个Session("username")的值做为查询,让数据表中的其它字段显示在其它的textbox中。如何实现呢!我想问题一定是出来出在查询上面的,但不知如何解决,在下谢谢先!
Sub Page_Load(sender As Object, e As EventArgs)
dim sql as string
dim str as string=Session("username")
if not (Session("username") is nothing) then
Label1.Text = "<b>欢迎〖" & Session("username") & "〗登录!</b>"
tbHQBH.text=Session("username")
end if
Dim strConn As String
strConn = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source="&server.mappath("/qkglxt/data/data.mdb")
myConn = New OledbConnection(strConn) Sql = "SELECT username , tel as '" & tbHTJE.Text &"',email as '" & tbHTBD.Text &"',danwei as '" & tbHTYF.Text &"' FROM userinfo WHERE username = '" & str &"'"
end sub
Sub Page_Load(sender As Object, e As EventArgs)
dim sql as string
dim str as string=Session("username")
if not (Session("username") is nothing) then
Label1.Text = "<b>欢迎〖" & Session("username") & "〗登录!</b>"
tbHQBH.text=Session("username")
end if
Dim strConn As String
strConn = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source="&server.mappath("/qkglxt/data/data.mdb")
myConn = New OledbConnection(strConn) Sql = "SELECT username , tel as '" & tbHTJE.Text &"',email as '" & tbHTBD.Text &"',danwei as '" & tbHTYF.Text &"' FROM userinfo WHERE username = '" & str &"'"
end sub
可能有问题这里的as 不能用来赋值阿,as只是在sql语句的关键字
你需要把结果查询出来
用DataReader实现String mySelectQuery = "SELECT username , tel ,email FROM userinfo WHERE username = '" & str &"'"
SqlCommand myCommand = new SqlCommand(mySelectQuery);
SqlDataReader myReader = myCommand.ExecuteReader(); while(myReader.Read()) //循环读取数据
{
tbHTJE.Text =myReader["tel"].ToString(), }