紧急VB.NET中DataGridView控件如何使用
紧急!!!VB.NET中DataGridView控件怎么使用
如何用代码实现数据的绑定,我写了一个,可以连接到表,可是却不显示数据!大家帮帮忙吧!
Dim conn As OleDbConnection
Dim dataTable As OleDbDataAdapter
Dim dataSet As DataSet
Dim strSQL As String
Private Sub oprData_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
conn = New OleDbConnection()
conn = getDB_Conn()
'conn.Open()
strSQL = "select * from sys_hairstyle"
dataTable = New OleDbDataAdapter(strSQL, conn)
dataSet = New DataSet
dataTable.Fill(dataSet)
DataGridViewInfo.DataSource = dataSet.Tables(0)
DataGridViewInfo.AutoResizeRows()
conn.Close()
End Sub
高手们能给出使用操作的源代码是最好不过啦,先谢谢啦!
------解决方案--------------------
Dim conn As OleDbConnection
Dim dataTable As OleDbDataAdapter
Dim dataSet As DataSet
Dim strSQL As String
Private Sub oprData_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
conn = New OleDbConnection()
conn = getDB_Conn()
'conn.Open()
strSQL = "select * from sys_hairstyle"
dataTable = New OleDbDataAdapter(strSQL, conn)
dataSet = New DataSet
dataTable.Fill(dataSet)
DataGridViewInfo.DataSource = dataSet.Tables(0)
DataGridViewInfo.AutoResizeRows()
DataGridViewInfo.DataBind()
conn.Close()
End Sub
------解决方案--------------------
Dim dataSet As DataSet
dataSet = New DataSet
dataTable.Fill(dataSet)
有没有可能是这样的命名冲突了.
干吗使用相同的名称呢.换一个别的名字试试.
如何用代码实现数据的绑定,我写了一个,可以连接到表,可是却不显示数据!大家帮帮忙吧!
Dim conn As OleDbConnection
Dim dataTable As OleDbDataAdapter
Dim dataSet As DataSet
Dim strSQL As String
Private Sub oprData_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
conn = New OleDbConnection()
conn = getDB_Conn()
'conn.Open()
strSQL = "select * from sys_hairstyle"
dataTable = New OleDbDataAdapter(strSQL, conn)
dataSet = New DataSet
dataTable.Fill(dataSet)
DataGridViewInfo.DataSource = dataSet.Tables(0)
DataGridViewInfo.AutoResizeRows()
conn.Close()
End Sub
高手们能给出使用操作的源代码是最好不过啦,先谢谢啦!
------解决方案--------------------
Dim conn As OleDbConnection
Dim dataTable As OleDbDataAdapter
Dim dataSet As DataSet
Dim strSQL As String
Private Sub oprData_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
conn = New OleDbConnection()
conn = getDB_Conn()
'conn.Open()
strSQL = "select * from sys_hairstyle"
dataTable = New OleDbDataAdapter(strSQL, conn)
dataSet = New DataSet
dataTable.Fill(dataSet)
DataGridViewInfo.DataSource = dataSet.Tables(0)
DataGridViewInfo.AutoResizeRows()
DataGridViewInfo.DataBind()
conn.Close()
End Sub
------解决方案--------------------
Dim dataSet As DataSet
dataSet = New DataSet
dataTable.Fill(dataSet)
有没有可能是这样的命名冲突了.
干吗使用相同的名称呢.换一个别的名字试试.