asp.net登录窗口如何连接数据库判断用户名
我写了一个登陆程序,需要调用sqldatasource进行验证,如何调用这个过程进行验证呢?谢谢
<li class="three">
<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:ConnectionString2 %>" ProviderName="<%$ ConnectionStrings:ConnectionString2.ProviderName %>" SelectCommand="SELECT [code], [s_name], [u_name], [u_mima], [u_ind] FROM [user_index] WHERE ([u_name] = '" & textbox1.text.trim()) & "[u_mima] = " & textbox2.text.trim() & ">
<SelectParameters>
<asp:Parameter DefaultValue="textbox1.text.trim()" Name="u_name" Type="String" />
</SelectParameters>
</asp:SqlDataSource>
SqlDataSource的属性这样设置正确吗,我使用的是 vb.net
我自己写了一个判断语句,但是不知道如何获得查询记录总条数,以便进行下一步动作。
Protected Sub Button1_Click(sender As Object, e As EventArgs) Handles Button1.Click
If TextBox1.Text.Trim() = "" Then
Response.Write("<script>window.alert('用户名不能为空!');</script>")
Exit Sub
End If
Dim cx As String
cx = "select * from user_index where u_name='" + TextBox1.Text + " u_mima='" + TextBox2.Text + "'"
SqlDataSource1.SelectCommand = cx
End Sub
Protected Sub SqlDataSource1_Selected(sender As Object, e As EventArgs)
Dim rowCount As Integer
rowCount = e.Equals
If e.AffectedRows Then
Response.Write(rowCount.ToString())
End If
End Sub
<li class="three">
<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:ConnectionString2 %>" ProviderName="<%$ ConnectionStrings:ConnectionString2.ProviderName %>" SelectCommand="SELECT [code], [s_name], [u_name], [u_mima], [u_ind] FROM [user_index] WHERE ([u_name] = '" & textbox1.text.trim()) & "[u_mima] = " & textbox2.text.trim() & ">
<SelectParameters>
<asp:Parameter DefaultValue="textbox1.text.trim()" Name="u_name" Type="String" />
</SelectParameters>
</asp:SqlDataSource>
SqlDataSource的属性这样设置正确吗,我使用的是 vb.net
我自己写了一个判断语句,但是不知道如何获得查询记录总条数,以便进行下一步动作。
Protected Sub Button1_Click(sender As Object, e As EventArgs) Handles Button1.Click
If TextBox1.Text.Trim() = "" Then
Response.Write("<script>window.alert('用户名不能为空!');</script>")
Exit Sub
End If
Dim cx As String
cx = "select * from user_index where u_name='" + TextBox1.Text + " u_mima='" + TextBox2.Text + "'"
SqlDataSource1.SelectCommand = cx
End Sub
Protected Sub SqlDataSource1_Selected(sender As Object, e As EventArgs)
Dim rowCount As Integer
rowCount = e.Equals
If e.AffectedRows Then
Response.Write(rowCount.ToString())
End If
End Sub
...全文
请发表友善的回复…
发表回复
welcome520 2019-05-19
- 打赏
- 举报
这段代码不是用在这里的,你应该找更优化代码
王长伟 2019-05-19
- 打赏
- 举报
资料已经找到
da = New SqlDataAdapter("select * from Department", conn)
ds = New DataSet
da.Fill(ds, "MyDepartment")
DepartmentNum = ds.Tables("MyDepartment").Rows.Count
我的意思是找到记录总数,这个应该能够解决我的问题,谢谢大家的回答。
da = New SqlDataAdapter("select * from Department", conn)
ds = New DataSet
da.Fill(ds, "MyDepartment")
DepartmentNum = ds.Tables("MyDepartment").Rows.Count
我的意思是找到记录总数,这个应该能够解决我的问题,谢谢大家的回答。
秋的红果实 2019-05-16
- 打赏
- 举报
cx = "select * from user_index where u_name='" + TextBox1.Text + "' and u_mima='" + TextBox2.Text + "'"