将ListView问题与数据库绑定 [英] Binding ListView Question with Database
本文介绍了将ListView问题与数据库绑定的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
您好,
1>如何将ListView绑定到vb.net windows应用程序中的Database表。
2>如何在vb.net中将listView复选框(Windows )
Hello,
1>How to bind ListView to Database table in vb.net windows application.
2>how to checkbox to listView in vb.net(Windows)
推荐答案
你好
如果你打算使用ADO.Net
Hello
If you are going to use ADO.Net
How to Fill a ListView with any ADO.Net Dataset
Dim ds作为新数据集
Dim con As New SqlClient.SqlConnection(constr)
con.Open()
Dim sqladap As New SqlClient.SqlDataAdapter(" select * from tbl_Employee",con)
sqladap.Fill(ds)
For i As Integer = 0 to ds.Tables(0).Co lumns.Count - 1
ListView1.Columns.Add(ds.Tables(0).Columns(i).ToString())
下一页
For i As Integer = 0 to ds.Tables(0).Rows.Count - 1
Dim listRow As New ListViewItem
listRow.Text = ds.Tables( 0).Rows(i)(0).ToString()
对于j As Integer = 1到ds.Tables(0).Columns.Count - 1
listRow .SubItems.Add(ds.Tables(0).Rows(i)(j).ToString())
下一页
ListView1.Items.Add(listRow)
下一页
问候
Ronal
Hi,
Dim ds As New DataSet
Dim con As New SqlClient.SqlConnection(constr)
con.Open()
Dim sqladap As New SqlClient.SqlDataAdapter("select * from tbl_Employee", con)
sqladap.Fill(ds)
For i As Integer = 0 To ds.Tables(0).Columns.Count - 1
ListView1.Columns.Add(ds.Tables(0).Columns(i).ToString())
Next
For i As Integer = 0 To ds.Tables(0).Rows.Count - 1
Dim listRow As New ListViewItem
listRow.Text = ds.Tables(0).Rows(i)(0).ToString()
For j As Integer = 1 To ds.Tables(0).Columns.Count - 1
listRow.SubItems.Add(ds.Tables(0).Rows(i)(j).ToString())
Next
ListView1.Items.Add(listRow)
Next
Regards
Ronal
这篇关于将ListView问题与数据库绑定的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文