asp.net – 如何通过sqldatasource计算获取的行数
发布时间:2020-12-16 03:20:00 所属栏目:asp.Net 来源:网络整理
导读:Protected Sub Button1_Click(ByVal sender As Object,ByVal e As EventArgs) Handles Button1.Click Dim LoginChecker As New SqlDataSource() LoginChecker.ConnectionString = ConfigurationManager.ConnectionStrings("A1ConnectionString1").ToString()
Protected Sub Button1_Click(ByVal sender As Object,ByVal e As EventArgs) Handles Button1.Click Dim LoginChecker As New SqlDataSource() LoginChecker.ConnectionString = ConfigurationManager.ConnectionStrings("A1ConnectionString1").ToString() LoginChecker.SelectCommandType = SqlDataSourceCommandType.Text LoginChecker.SelectCommand = "SELECT username FROM A1login WHERE username=@username AND password=@password" LoginChecker.SelectParameters.Add("username",username.Text) LoginChecker.SelectParameters.Add("password",password.Text) Dim rowsAffected As Integer = 0 Try rowsAffected = LoginChecker.<what i have to write here> Catch ex As Exception 'Server.Transfer("LoginSucessful.aspx") Finally LoginChecker = Nothing End Try username.Text = rowsAffected ' If rowsAffected = 1 Then 'Server.Transfer("A1success.aspx") ' Else 'Server.Transfer("A1failure.aspx") ' End If End Sub 这是login.aspx.vb的代码 解决方法protected void Button1_Click(object sender,EventArgs e) { DataView d =(DataView) SqlDataSource1.Select(DataSourceSelectArguments.Empty); Response.Write(d.Count); } (编辑:李大同) 【声明】本站内容均来自网络,其相关言论仅代表作者个人观点,不代表本站立场。若无意侵犯到您的权利,请及时与联系站长删除相关内容! |
推荐文章
站长推荐
- asp.net – 如何拒绝用户访问子文件夹和文件?
- 如何ASP.NET Core Razor中处理Ajax请求
- 再谈消息队列技术
- asp.net-mvc – 无法在asp mvc项目中从iis上的Co
- asp.net-mvc – MVC4表单输入验证 – 自定义错误
- asp.net – WSDL.exe工具的/ serverInterface和/
- asp.net-mvc – 使用jQuery.post将多个参数发布到
- ASP.NET MVC 4实体框架6 SQL Compact Edition 4.
- asp.net-mvc – MVC 5捆绑和Azure CDN(查询字符串
- asp.net-mvc-3 – ASP.NET MVC 3 RTM项目中的这个
热点阅读