请教一个VB.NET的问题
我创建了一个类,分别用来执行SELECT在WEB页面中点击按钮代码如下:却提示出错,SQL事件控查已执行过,请教一下代码错在那里?
Protected Sub Button4_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button4.Click
Dim mycon As conn
Dim dt As New Data.DataTable
Dim Rs As Data.DataSet
mycon = New conn
Rs = mycon.rsdb
Rs = mycon.QuerySql("Select * from t_UserPrv where FUser=" + "'" & TextBox1.Text & "'", "t_userPrv")
MsgBox(Rs.Tables("t_userprv").Rows(1)(0).ToString()) '运行到这出错
End Sub
'------------- 执行SQL类--------------------------------------------------------------------
Public Class conn
'Public rsdb As Data.DataSet
Public Function QuerySql(ByVal strSql As String, ByVal TableName As String) As Data.DataSet
Dim myDs As New Data.DataSet
Dim sqlConn As SqlConnection = New SqlConnection(ConfigurationManager.AppSettings("Conntction"))
Dim Myds As New Data.DataSet
Dim myCmd As SqlCommand = New SqlCommand(strSql, sqlConn)
Dim myDa As New SqlDataAdapter(strSql, sqlConn)
Try
myDa.Fill(Myds, TableName)
'rsdb = Myds
Catch er As Exception
Finally
sqlConn.Close()
End Try
Return Myds
End Function
End class
Protected Sub Button4_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button4.Click
Dim mycon As conn
Dim dt As New Data.DataTable
Dim Rs As Data.DataSet
mycon = New conn
Rs = mycon.rsdb
Rs = mycon.QuerySql("Select * from t_UserPrv where FUser=" + "'" & TextBox1.Text & "'", "t_userPrv")
MsgBox(Rs.Tables("t_userprv").Rows(1)(0).ToString()) '运行到这出错
End Sub
'------------- 执行SQL类--------------------------------------------------------------------
Public Class conn
'Public rsdb As Data.DataSet
Public Function QuerySql(ByVal strSql As String, ByVal TableName As String) As Data.DataSet
Dim myDs As New Data.DataSet
Dim sqlConn As SqlConnection = New SqlConnection(ConfigurationManager.AppSettings("Conntction"))
Dim Myds As New Data.DataSet
Dim myCmd As SqlCommand = New SqlCommand(strSql, sqlConn)
Dim myDa As New SqlDataAdapter(strSql, sqlConn)
Try
myDa.Fill(Myds, TableName)
'rsdb = Myds
Catch er As Exception
Finally
sqlConn.Close()
End Try
Return Myds
End Function
End class
...全文
相关推荐
Vb.Net问题集.rar_VB .net_vb.net_vb.net_
vb.net中常见的问题
棋盘问题VB.NET
设有x*y个方格的棋盘,求出该棋盘中包含多少个正方形、多少个长方形(不包括正方形).
汉诺塔问题 VB.NET
汉诺塔问题用VB.NET实现的,比较形象的,
VB.net-Kill命令出现问题
我假设您要通过代码而不是通过IE选项对话框来实现此目的。Kill用于终止进程,System.IO.File.Delete [^]用于删除文件
.net和 vb WebBrowser 浏览器兼容问题
.net和 vb WebBrowser 浏览器兼容问题自己封装的开发中遇到的第一次加载注册表可能未注册 F5一下就会成功



