datasource是我定义的一个类
Imports Microsoft.VisualBasic
Imports System.Data.OleDb
Imports System.DataPublic Class DataClass Private connstr As String
Private sqlConnection As OleDbConnection
Private sqlDataAdapter As OleDbDataAdapter
Private sqlDataReader As OleDbDataReader
Private sqlCommand As OleDbCommand
Private sqlDataset As DataSet Public Function TdataSet(ByVal QueryString As String) As DataSet
Me.sqlDataAdapter = New OleDbDataAdapter(QueryString, Me.sqlConnection)
Dim dataSet As New DataSet
Me.sqlDataAdapter.Fill(dataSet)
Return dataSet
End FunctionPublic Sub New()
Me.connstr = "provider=MSDAORA;Data Source=test2;Persist Security Info=True;User ID=system;Password=manager;Unicode=True"
Me.sqlConnection = New OleDbConnection(Me.connstr)
Me.sqlConnection.Open()
End SubEnd Class在一个页面中画了GridView控件,添加了一些列,用以下代码将GridView与数据源进行了绑定,不知道怎么讲查询的各个字段与每一列绑定,请达人帮忙,急,十分感谢。Dim [setgrid] As DataSet = datasource.TdataSet(queryString)
Me.GridView1.DataSource = [setgrid]
Me.GridView1.DataBind()
Imports Microsoft.VisualBasic
Imports System.Data.OleDb
Imports System.DataPublic Class DataClass Private connstr As String
Private sqlConnection As OleDbConnection
Private sqlDataAdapter As OleDbDataAdapter
Private sqlDataReader As OleDbDataReader
Private sqlCommand As OleDbCommand
Private sqlDataset As DataSet Public Function TdataSet(ByVal QueryString As String) As DataSet
Me.sqlDataAdapter = New OleDbDataAdapter(QueryString, Me.sqlConnection)
Dim dataSet As New DataSet
Me.sqlDataAdapter.Fill(dataSet)
Return dataSet
End FunctionPublic Sub New()
Me.connstr = "provider=MSDAORA;Data Source=test2;Persist Security Info=True;User ID=system;Password=manager;Unicode=True"
Me.sqlConnection = New OleDbConnection(Me.connstr)
Me.sqlConnection.Open()
End SubEnd Class在一个页面中画了GridView控件,添加了一些列,用以下代码将GridView与数据源进行了绑定,不知道怎么讲查询的各个字段与每一列绑定,请达人帮忙,急,十分感谢。Dim [setgrid] As DataSet = datasource.TdataSet(queryString)
Me.GridView1.DataSource = [setgrid]
Me.GridView1.DataBind()
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货