VB.NET 連接數據庫後的操作

ACmd.CommandText = AFind 下面要加上壹句執行

ACmd.ExecuteNonQuery()

-------------------------------------

要寫查詢到控件DataGridView的話，可以這樣做：.net2.0或以上的環境中：

Dim AConnect As OleDb.OleDbConnection

Dim ACmd As OleDb.OleDbCommand

Dim dtResult As DataTable=new DataTable()

Dim ConnectStr As String = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Application.StartupPath & "\Enroll.mdb"

Dim AFind As String = "SELECT * FROM rj"

AConnect = New OleDb.OleDbConnection(ConnectStr)

AConnect.Open()

ACmd = New OleDb.OleDbCommand(AFind, AConnect)

ACmd.CommandText = AFind

Dim ADr as OleDb.OleDbDataReader=ACmd.ExcuteReader()

dtResult.Load(ADr)

AConnect.Close()

DataGridView.DataSource=dtResult

---------

希望能符合妳的需求

上一篇:全套多少錢

下一篇:網紅拳手KO了扣籃王，卻害怕詹姆斯：他太高了，太強大了