当前位置: 代码迷 >> ASP.NET >> 大家帮小弟我看看,登陆代码
  详细解决方案

大家帮小弟我看看,登陆代码

热度:3245   发布时间:2013-02-25 00:00:00.0
大家帮我看看,登陆代码?
刚学.net呀!哈哈!
Protected Sub Button1_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button1.Click
  '创建数据库链接
  Dim sqlconn As SqlConnection
  Dim strconn As String
  strconn = "data source=yh;initial catalog=admin;user id=sa;password=sql2005"
  sqlconn = New SqlConnection(strconn)
  sqlconn.Open()

  '创建command对象
  Dim sqlcmd As New SqlCommand
  sqlcmd.Connection = sqlconn
  sqlcmd.CommandType = Data.CommandType.Text
  sqlcmd.CommandText = "selet Name,Password from admininfo where [Name] = '" + TextBox1.Text + "' And [Password] = '" + TextBox2.Text + "'"

  '创建datareader对象
  Dim sqldr As SqlDataReader
  sqldr = sqlcmd.ExecuteReader

  Dim i As Integer = sqlcmd.ExecuteNonQuery
  If i <> 1 Then
  Response.Redirect("Register.aspx")
  End If
  End Sub
“/Login”应用程序中的服务器错误。
--------------------------------------------------------------------------------

关键字 'from' 附近有语法错误。
先谢谢了!!!!!

------解决方案--------------------------------------------------------
"select Name,Password from admininfo where [Name] = '" + TextBox1.Text + "' And [Password] = '" + TextBox2.Text + "'" 

是select拼写错误

------解决方案--------------------------------------------------------
是select拼写错误

晕死!!!!!!!!
------解决方案--------------------------------------------------------
呵呵。。。。。。
初学都会有过。。。
  相关解决方案