ado.net

goodday

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

goodhermit95

我考试
考完式还有很多东西作
没有空

JUNIOR MIDDLE ONE 18 CD AUTORUN MENU
- PROCESS.START -> MOVIE
- PROCESS.START - PICTURE
- MOVIE BROWSER
- PHOTO BROWSER
- COPY FILE TO HARDDISK
- UPDATE SYSTEM
- ABOUT

YOUTUBE VIDEO DOWNLOADER <科级比赛拿去
COMPERTITION - INTERNET NOVEL <我要写两篇

帮你做工

这个假期我很忙咯

PS:GOODHERMIT85?我那么老啊

[ 本帖最后由 goodhermit95 于 2008-10-22 05:16 PM 编辑 ]

zechs

为什么我名字前面多两个字

goodhermit95

这个是他的台词呀