关于读取数据库导入DATAGRIDVIEW表里
我想把数据库里的数据导入DATAGRIDVIEW1的表里,下面是我的代码.但是有问题出现.
表.HeaderCell的值不显示.
有什么好方法吗?
Dim cmd As OleDbCommand = New OleDbCommand("select * from tMacMas", objConn)
Dim dr As OleDbDataReader = cmd.ExecuteReader()
Dim intloop As Integer
intloop = 0
If Not (dr Is Nothing) Then
Do While (dr.Read() = True)
Dim m_ID As Integer = dr.GetInt32(0)
Dim m_MAc As String = dr.GetString(1)
Dim m_SER As String = dr.GetString(2)
DataGridView1.Rows.Add(objds.Tables)
DataGridView1.Rows(intloop).HeaderCell.Value = m_ID
DataGridView1.Rows(intloop).Cells(0).Value = m_MAc
DataGridView1.Rows(intloop).Cells(1).Value = m_SER
intloop = intloop + 1
Loop
'intloop = 0
End If --------------------编程问答-------------------- 怎么没有人肯帮忙吗?
--------------------编程问答-------------------- 用DataSet来传递数据不是很方便吗?
Dim MyCommand As OleDbCommand
Dim MyDataAdapter As OleDbDataAdapter
Dim MyDataSet As New DataSet()
MyConnection.Open()
MyCommand = New OleDbCommand("select * from tMacMas", MyConnection)
MyDataAdapter = New OleDbDataAdapter(MyCommand)
MyDataAdapter.Fill(MyDataSet, "tMacMas")
DataGridView1.DataSource = MyDataSet
DataGridView1.DataMember = "tMacMas"
--------------------编程问答-------------------- 我用了,但是DataGridView1.Rows(intloop).HeaderCell.Value = m_ID 我想把数据库中的ID号放到表的最左边.就是有星号的那列.
--------------------编程问答-------------------- 不知道你用的是VS什么版本?ID号的位置跟SQL语句的顺序是一致的,你用的是select * from tMacMas,那么ID号就是你数据库中的位置(在数据库中保证你的ID号在最左边)。 --------------------编程问答-------------------- dataset不是很方便吗?
补充:.NET技术 , VB.NET