dbConnection = New OleDb.OleDbConnection(dbConnectionString)
dbConnection.Open()
Return dbConnection
Catch ex As Exception
Return False
End Try
End Function
Public Function ConnectionClose()
Try
dbConnection.Close()
dbConnection.Dispose()
Return dbConnection
Catch ex As Exception
Return False
End Try
End Function
Public Function getSqlData(ByVal strSQL As String) As DataSet
Dim dataSet As New DataSet
Dim DataAdapter As New OleDb.OleDbDataAdapter
DataAdapter.SelectCommand = New OleDb.OleDbCommand(strSQL, dbConnection)
Try
DataAdapter.Fill(dataSet, "Table")
Catch Ex As Exception
MsgBox(Err.Description)
Finally
dataSet.Dispose()
DataAdapter.Dispose()
'dbConnection.Close()
'dbConnection.Dispose()
End Try
Return dataSet
End Function
**********************************************************************************
**********************************************************************************
实用例:
Private ConnDB As New ConnectionDB
Dim strSQL As String = ""
Dim dtData As DataSet
Try
ConnDB.ConnectionOpen()
strSQL = "select * from Maintable"
dtData = ConnDB.getSqlData(strSQL)
Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
'班级
Dim tblBanji As New DataTable
tblBanji.Columns.Add("Banji", Type.GetType("System.String"))
tblBanji.Rows.Add(tblBanji.NewRow)
tblBanji.Rows(0).Item("Banji") = "1年1班" tblBanji.Rows(1).Item("Banji") = "1年2班"
tblBanji.Rows(2).Item("Banji") = "1年3班"
tblBanji.Rows(3).Item("Banji") = "1年4班"
Public Structure student
Public banji As String
Public name As String
Public jiguan As String
Public tel As String
Public birday As String
End Structure
Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
'班级
Dim tblBanji As New DataTable
tblBanji.Columns.Add("Banji", Type.GetType("System.String"))
tblBanji.Rows.Add(tblBanji.NewRow)
tblBanji.Rows(0).Item("Banji") = "1年1班"
tblBanji.Rows(1).Item("Banji") = "1年2班"
tblBanji.Rows(2).Item("Banji") = "1年3班"
tblBanji.Rows(3).Item("Banji") = "1年4班"
'画面上显示
DataGridView1.DataSource = tblBanji
End Sub
Private Sub DataGridView1_SelectionChanged(ByVal sender As Object, ByVal e As System.EventArgs) Handles DataGridView1.SelectionChanged
'选择标题行,不做处理
If DataGridView1.CurrentCell Is Nothing Then
Exit Sub
End If
'最后一行不做处理
If IsDBNull(DataGridView1.CurrentCell.Value) Then Exit Sub
If DataGridView1.CurrentCell.Value.Equals("1年1班") Then
Dim tblName As New DataTable
tblName.Columns.Add("Name", Type.GetType("System.String"))
tblName.Rows.Add(tblName.NewRow)
tblName.Rows(0).Item("Name") = "張1"
tblName.Rows.Add(tblName.NewRow)
tblName.Rows(1).Item("Name") = "李1"
DataGridView2.DataSource = tblName
End If
If DataGridView1.CurrentCell.Value.Equals("1年2班") Then
Dim tblName As New DataTable
tblName.Columns.Add("Name", Type.GetType("System.String"))
tblName.Rows.Add(tblName.NewRow)
tblName.Rows(0).Item("Name") = "張2"
tblName.Rows.Add(tblName.NewRow)
tblName.Rows(1).Item("Name") = "李2"
DataGridView2.DataSource = tblName
End If
If DataGridView1.CurrentCell.Value.Equals("1年3班") Then
Dim tblName As New DataTable
tblName.Columns.Add("Name", Type.GetType("System.String"))
tblName.Rows.Add(tblName.NewRow)
tblName.Rows(0).Item("Name") = "張3"
tblName.Rows.Add(tblName.NewRow)
tblName.Rows(1).Item("Name") = "李3"
DataGridView2.DataSource = tblName
End If
If DataGridView1.CurrentCell.Value.Equals("1年4班") Then
Dim tblName As New DataTable
tblName.Columns.Add("Name", Type.GetType("System.String"))
tblName.Rows.Add(tblName.NewRow)
tblName.Rows(0).Item("Name") = "張4"
tblName.Rows.Add(tblName.NewRow)
tblName.Rows(1).Item("Name") = "李4"
DataGridView2.DataSource = tblName
End If
Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
ListBox1.Items.Add("一班")
ListBox1.Items.Add("二班")
ListBox1.Items.Add("三班")
End Sub
Class student
Public banji As String
Public name As String
Public jiguan As String
Public tel As Integer
Public birday As Date
Public Sub New()