Dim OleDbConnection1 As System.Data.OleDb.OleDbConnection
Dim OleDbDataAdapter1 As System.Data.OleDb.OleDbDataAdapter
Dim objtable As DataTable
Dim strcmd As String
Dim strconn As String
Dim objLink As New DataSet()
strconn = "Provider=SQLOLEDB.1;User ID=xx;pwd=xx;datasource=192.168.0.1;Initial Catalog=test;"
strcmd = "select * from tb "
OleDbConnection1 = New System.Data.OleDb.OleDbConnection(strconn)
OleDbDataAdapter1 = New System.Data.OleDb.OleDbDataAdapter(strcmd, OleDbConnection1)
OleDbDataAdapter1.Fill(objLink, "tb")
objtable = objLink.Tables("tb") '首天的查询
OleDbConnection1.Close()
dg1.DataSource = objtable.DefaultView
dg1.DataBind()
Dim OleDbDataAdapter1 As System.Data.OleDb.OleDbDataAdapter
Dim objtable As DataTable
Dim strcmd As String
Dim strconn As String
Dim objLink As New DataSet()
strconn = "Provider=SQLOLEDB.1;User ID=xx;pwd=xx;datasource=192.168.0.1;Initial Catalog=test;"
strcmd = "select * from tb "
OleDbConnection1 = New System.Data.OleDb.OleDbConnection(strconn)
OleDbDataAdapter1 = New System.Data.OleDb.OleDbDataAdapter(strcmd, OleDbConnection1)
OleDbDataAdapter1.Fill(objLink, "tb")
objtable = objLink.Tables("tb") '首天的查询
OleDbConnection1.Close()
dg1.DataSource = objtable.DefaultView
dg1.DataBind()
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货