平臺: vs2012
開發語言：vb
Protected Sub Buton1_Click(sender As Object, e As EventArgs) Handles Button1.Click
dim rs AS ADODB.Recordset
rs = New ADODB.Recordset
rs.ActiveConnection = "Provider=SQLOLEDB.1;Password=132;Persist Security Info=True;User ID=sa;Initial Catalog=db_news;Data Source=WIN-3L70IQHFNQL"
rs.CursorLocation = ADODB.CursorLocationEnum.adUseClient
rs.CursorType = ADODB.CursorTypeEnum.adOpenStatic
rs.Source = "select userid,UserName from td_user order by id"
rs.Open()
GridView1.DataSource = rs
uj5u.com熱心網友回復：
好少人用ADO了uj5u.com熱心網友回復：
rs.ActiveConnection應該是一個Connection物件，不是字串
，另GridView能系結Recordset？還是用DataSet或者DataTable吧
uj5u.com熱心網友回復：
錯誤資訊不足，無法排查什么原因啊！轉載請註明出處，本文鏈接：https://www.uj5u.com/net/41607.html
標籤：VB.NET
上一篇：C#讀取exce的資料匯入資料庫