sub button1_click(sender as object,e as eventargs)
Dim str As String
Dim passstr As String
‘获得用户填写的用户名和密码
passstr = Trim(CStr(ls_pass.Text))
str = "'" & ls_user.Text & "'"
‘连接数据库,打开emailuser表,查询该用户是否存在
Dim sql As String = "select * from emailuser where emailuser=" & Trim(str)
Dim connstr As String = "Provider=SQLOLEDB;server=oyzz;uid=sa;
pwd=;database=userdb"Dim myconn As New SqlClient.SqlConnection(connstr)
Dim da As New SqlClient.SqlDataAdapter(sql, myconn)
Dim ds As New SqlClient.DataSet()
da.Fill(ds, "emailuser")
‘如果用户名和密码匹配,那么显示“登录成功”,否则显示“密码错误!”
If ds.Tables("emailuser").Rows.Count = 1 Then
If passstr = Trim(ds.Tables("emailuser").Rows(0)("password")) Then
Session("xstr") = "登录成功"
Session("reguser") = str
Response.Redirect("welcome.aspx")
Else
Response.Write("密码错误!")
End If
Else
Response.Write("用户名输入错误!")
End If
end sub
有一些实在迷惑passstr = Trim(CStr(ls_pass.Text))
str = "'" & ls_user.Text & "'"
If ds.Tables("emailuser").Rows.Count = 1 Then
If passstr = Trim(ds.Tables("emailuser").Rows(0)("password")) Then
Session("xstr") = "登录成功"
Session("reguser") = str
Response.Redirect("welcome.aspx")这两段代码写成c#应该怎样写呢?
Dim str As String
Dim passstr As String
‘获得用户填写的用户名和密码
passstr = Trim(CStr(ls_pass.Text))
str = "'" & ls_user.Text & "'"
‘连接数据库,打开emailuser表,查询该用户是否存在
Dim sql As String = "select * from emailuser where emailuser=" & Trim(str)
Dim connstr As String = "Provider=SQLOLEDB;server=oyzz;uid=sa;
pwd=;database=userdb"Dim myconn As New SqlClient.SqlConnection(connstr)
Dim da As New SqlClient.SqlDataAdapter(sql, myconn)
Dim ds As New SqlClient.DataSet()
da.Fill(ds, "emailuser")
‘如果用户名和密码匹配,那么显示“登录成功”,否则显示“密码错误!”
If ds.Tables("emailuser").Rows.Count = 1 Then
If passstr = Trim(ds.Tables("emailuser").Rows(0)("password")) Then
Session("xstr") = "登录成功"
Session("reguser") = str
Response.Redirect("welcome.aspx")
Else
Response.Write("密码错误!")
End If
Else
Response.Write("用户名输入错误!")
End If
end sub
有一些实在迷惑passstr = Trim(CStr(ls_pass.Text))
str = "'" & ls_user.Text & "'"
If ds.Tables("emailuser").Rows.Count = 1 Then
If passstr = Trim(ds.Tables("emailuser").Rows(0)("password")) Then
Session("xstr") = "登录成功"
Session("reguser") = str
Response.Redirect("welcome.aspx")这两段代码写成c#应该怎样写呢?
解决方案 »
- 通过“添加”按钮将textarea中的内容添加到指定的数据库中,该怎么办
- asp.net控件问题
- asp.net文件上传
- 有谁知道asp:Repeater的3个样式交替怎么弄吗?
- 关于跨用户访问对象的问题
- 以横向树方式显示Html表格
- 如何用ASP.NET实现下载的功能
- 弱弱的问:怎样在自定义的类中应用wenform 中的函数
- 重装mdac请,拷贝win2003的C:\winnt\system32下的这三个文件发送到[email protected]谢谢。
- 简单的问题但你们不一定会,请看,会有受益的!
- 求权限管理和分配 vb 源码(包括角色、权限) 200分相送
- 不通过在客户端写代码,如何只通过服务器端创建一个iframe,并且赋给它一些属性?
str = "'" + ls_user.Text + "'";if (ds.Tables["emailuser"].Rows.Count == 1)
{
if (passstr == ds.Tables["emailuser"].Rows[0]["password"].ToString().Trim())
{
Session["xstr"] = "登录成功";
Session["reguser"] = str;
Response.Redirect("welcome.aspx");
}
}