Imports System.Data
Imports System.Data.OleDb
Imports System
这些应该放在哪个文件的哪个位置?
我把它们放在GLOBAL.ASAX文件中,在session_start等过程中调用
dim com as sqlconnection 时,在弹出栏中根本就没有sqlconnection,只有sqlclient,
不知问题出在哪?
...全文
16912打赏收藏
ASP.NET+VB,高手请过
Imports System.Data Imports System.Data.OleDb Imports System 这些应该放在哪个文件的哪个位置? 我把它们放在GLOBAL.ASAX文件中,在session_start等过程中调用 dim com as sqlconnection 时,在弹出栏中根本就没有sqlconnection,只有sqlclient, 不知问题出在哪?
写在模块里
Public conn As New SqlConnection("uid=sa;database=cp;server=localhost")
Public Sub CONN_Open()
If conn.State = ConnectionState.Closed Then
conn.Open()
End If
End Sub
你页面的代码
Dim Myada As New SqlDataAdapter("select * from cp11", conn)
Dim ds As New DataSet
conn_open
Myada .fill(ds)
conn.close
DataGrid1.DataSource = ds.table(0).defaultview
DataGrid1.DataBind()
用VB。NET的好处就是经常用的代码可以写进模块里
我把Public conn As New SqlConnection(sqlconn)
Public Sub CONN_Open()
If conn.State = ConnectionState.Closed Then
conn.Open()
End If
End Sub
写在模块里
Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
Dim nowconn As SqlConnection = New SqlConnection("uid=sa;database=cp;server=localhost")
Dim ncomm As SqlCommand = New SqlCommand("select * from cp11", nowconn)
Dim ds As New DataSet
ncomm.filldataset(ds, "cp")
DataGrid1.DataSource = ds.table("cp11").defaultview
DataGrid1.DataBind()
'在此处放置初始化页的用户代码
End Sub
提示 ncomm.filldataset(ds, "cp")ncomm没有定义filldataset