C # Winform about ListView Control binding DataTable

Today we use the ListView control, which summarizes the way the ListView control binds to the DataTable

It is important to note that the binding process implements the property of the bound control's column and then the item's binding.

Unlike DataGridView, you cannot use datasourse bindings directly,

Furthermore, when binding the first items, be sure to instantiate an item for a separate binding, because the first item is the difference from the next without the item to the subitem, and the corresponding comment is given in the code below.

[CSharp]View PlainCopy

2. Private void LoadData ()
4. {
6. String sql = @"SELECT * from";
8. DataTable dt = dbutil.getdatatable (SQL);
12. this.listView1.Columns.Clear (); //Good habits, first clear and then add to ensure consistency of data
14. this.listView1.Columns.Add ("Roomid");
16. this.listView1.Columns.Add ("Typeids");
18. this.listView1.Columns.Add ("price");
22. this.listView1.Items.Clear ();
26. int length = dt.  Rows.Count;
30. For (int i = 0; i < length; i++)
32. {
34. ListViewItem LVI = new ListViewItem (dt. rows[i]["Roomid"].  ToString ()); //listview's first item needs to be added separately as a master item
38. string typeid = dt. rows[i]["Typeids"].  ToString ();
42. switch (typeid)
44. {
46. case "1":
48. Lvi.   ImageIndex = 0; //Set the type of picture that is bound for each item type
50. Break ;
52. case "2":
54. Lvi. ImageIndex = 1;
56. Break ;
58. Case "3":
60. Lvi. ImageIndex = 2;
62. Break ;
66. Default:
68. Break ;
70. }
74. Lvi. SubItems.Add (dt. rows[i]["Typeids"].   ToString ()); //The item that is added later is subitems, which is the child
76. Lvi. SubItems.Add (dt. rows[i]["Price"].  ToString ());
78. This.listView1.Items.Add (LVI); //Last add
80. }
82. }

C # Winform about ListView Control binding DataTable