62,071
社区成员
发帖
与我相关
我的任务
分享
<asp:SqlDataSource ID="SqlDataSource1" runat="server"
ConnectionString="<%$ ConnectionStrings:你的连接字符 %>"
onselected="SqlDataSource1_Selected"
SelectCommand="SELECT * FROM [gn_pwd] WHERE (([name] = @name) AND ([pwd] = @pwd))">
<SelectParameters>
<asp:Parameter Name="name" Type="String" />
<asp:Parameter Name="pwd" Type="String" />
</SelectParameters>
</asp:SqlDataSource>
Protected Sub Button1_Click(ByVal sender As Object, ByVal e As EventArgs) Handles Button1.Click
If TextBox1.Text = "" Or TextBox2.Text = "" Then
Label1.Text = "错误:请先输入!"
Else
SqlDataSource1.SelectParameters("name").DefaultValue = TextBox1.Text
SqlDataSource1.SelectParameters("pwd").DefaultValue = TextBox2.Text
SqlDataSource1.Select(DataSourceSelectArguments.Empty)
End If
End Sub
Private Sub SqlDataSource1_Selected(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.SqlDataSourceStatusEventArgs) Handles SqlDataSource1.Selected
Label1.Text = e.AffectedRows
End Sub
If TextBox1.Text = "" Or TextBox2.Text = "" Then
Label1.Text = "错误:请先输入!"
Else
SqlDataSource1.[Select](DataSourceSelectArguments.Empty)
End If
Private Sub SqlDataSource1_Selected(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.SqlDataSourceStatusEventArgs) Handles SqlDataSource1.Selected
Label1.Text = e.AffectedRows
End Sub