goodday
2008-10-21 05:57 PM
Figure 1 DataGrid, DataSet and DataTable relationship diagram
资料提供
衰仔 zechs
受益人 goodhermit85
post 贴人 goodday
http://www.codeproject.com/KB/grid/practicalguidedatagrids1.aspx
不明就发问
Imports System.Data.OleDB
Public Class Form1 Inherits System.Windows.Forms.Form
Dim myConnection As OleDbConnection 定义connector
Dim myCommand As OleDbCommand 定义command
Dim dr As New OleDbDataReader() 定义 装资料的 箱
Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
myConnection = New OleDbConnection("Provider=MSDAORA.1;UserID=scott;password=tiger; database=ora")
MSDORA 是oracle 的
myConnection.Open() 接到database
myCommand = New OleDbCommand("Select * from emp", myConnection) 定义SQL的
dr = myCommand.ExecuteReader() 把资料拉出来 装在 dr 的箱
While dr.Read() 当dr有资料就
MessageBox.Show("EmpNo" & dr(0)) pop出来 EmpNo
MessageBox.Show("EName" & dr(1)) pop出来 EName
MessageBox.Show("Job" & dr(2)) pop出来 Job
MessageBox.Show("Mgr" & dr(3)) pop出来 Mgr
MessageBox.Show("HireDate" & dr(4))
End While
dr.Close()
myConnection.Close() 关掉database
End Sub
End Class
