![]() | Datagridview | ![]() |
| 1. Introduction to Datagridview |
|
| 2. Updating Table |
|
| 3. MyODBC & MyConnection |
3.1 load myodbc to datagridview
Imports System.Data.Odbc
Public Class Form1
Private Sub Form1_Load(ByVal sender As System.Object, _
ByVal e As System.EventArgs) Handles MyBase.Load
Dim ConnString As String = "Dsn=modbc351mysql;Uid=admin;Pwd=p"
Dim sql As String = "select user,password from user"
Dim Conn As OdbcConnection = New OdbcConnection(ConnString)
Dim Cmd As OdbcCommand = New OdbcCommand(sql, Conn)
Dim ReaderCat As OdbcDataReader = Cmd.ExecuteReader()
Dim s As String = ""
Conn.Open()
Do While ReaderCat.Read()
s &= ">" & ReaderCat.GetString(0) & Chr(10)
Loop
ReaderCat.Close()
Conn.Close()
DataGridView1.Rows(0).Cells(0).Value = s
End Sub
End Class
3.2 load myconnection to datagridview
Imports System.Data.Odbc
Public Class Form1
Private Sub Form1_Load(ByVal sender As System.Object, _
ByVal e As System.EventArgs) Handles MyBase.Load
Dim ConnString As String = "Dsn=modbc351mysql;Uid=admin;Pwd=p"
Dim sql As String = "select user,password from user"
Dim myConnection As OdbcConnection
myConnection = New OdbcConnection
myConnection.ConnectionString = ConnString
myConnection.Open()
Dim da As New OdbcDataAdapter(sql, myConnection)
Dim CmdB As New OdbcCommandBuilder(da)
Dim ds As New DataSet
da.Fill(ds, "user") ' put user table to dataset
Dim dv As New DataView
dv.Table = ds.Tables("user") ' put dataset to dataview
DataGridView1.DataSource = dv
End Sub
End Class
|
| 4. put row by row |
Put data to datagrid
Imports system.data.oledb
Public Class Form1
Dim strdb As String = "c:\northwind.mdb"
Dim strconn As String
strconn = "provider=microsoft.jet.oledb.4.0;data source=" & strdb
Dim strsql As String
Dim cn As New System.Data.OleDb.OleDbConnection(strconn)
Dim cm As New OleDbCommand(strsql, cn)
Dim dr As OleDbDataReader
Private Sub Form1_Load(ByVal sender As System.Object, _
ByVal e As System.EventArgs) Handles MyBase.Load
Dim x As Integer = DataGridView1.Columns.Count()
Dim i As Integer = 0
For i = 0 To x : DataGridView1.Columns.Clear() : Next
strsql = "select * from employees"
cm = New OleDbCommand(strsql, cn)
cn.Open()
dr = cm.ExecuteReader()
DataGridView1.Columns.Add("eid", "eid")
DataGridView1.Columns.Add("ename", "ename")
Do While dr.Read()
x = DataGridView1.Rows.Count() - 1
DataGridView1.Rows.Add()
DataGridView1.Rows(x).Cells(0).Value = dr.Item(0)
DataGridView1.Rows(x).Cells(1).Value = dr.Item(1)
Loop
cn.Close()
End Sub
End Class
|
|
5. resize of datagridview
(undock in parent container) |
Public Class Form1
Private Sub Form1_Load( ...
resizeme()
End Sub
Sub resizeme()
Dim gap As Integer = 30
DataGridView1.Left = 0
DataGridView1.Top = gap
DataGridView1.Width = Me.Width - 6
DataGridView1.Height = Me.Height - 25 - gap
End Sub
Private Sub Form1_Resize( ...
resizeme()
End Sub
End Class
|
| Web Guides |
+ http://www.thaiall.com/vbnet/datagridview_text.htm + http://www.thaiall.com/vbnet/datagridview_update.htm + http://www.thaiall.com/vbnet/sql_dbthai.htm + http://www.thaiall.com/vbnet/mysql_odbc.htm |