ListView control

Use This Code to fill the List View public ListView FillListView(ListView ltView,SqlDataReader DReader) { ColumnHeader clnHeader; string strText; int i,j; ltView.Clear(); for (i=0;i<=DReader.FieldCount-1;i++) { clnHeader=new ColumnHeader(); clnHeader.Text=DReader.GetName(i); ltView.Columns.Add(clnHeader); } while (DReader.Read()) { ListViewItem itmList=new ListViewItem(); strText=DReader.GetString(0).ToString(); itmList.Text=strText; for (j=1;j<=DReader.FieldCount-1;j++) { if(DReader.IsDBNull(j)) { itmList.SubItems.Add(""); } else { itmList.SubItems.Add(DReader.GetString(j)); } } ltView.Items.Add(itmList); } return ltView; }

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Ravi Kumar Neelam21y ago
Use This Code to fill the List View public ListView FillListView(ListView ltView,SqlDataReader DReader) { ColumnHeader clnHeader; string strText; int i,j; ltView.Clear(); for (i=0;i<=DReader.FieldCount-1;i++) { clnHeader=new ColumnHeader(); clnHeader.Text=DReader.GetName(i); ltView.Columns.Add(clnHeader); } while (DReader.Read()) { ListViewItem itmList=new ListViewItem(); strText=DReader.GetString(0).ToString(); itmList.Text=strText; for (j=1;j<=DReader.FieldCount-1;j++) { if(DReader.IsDBNull(j)) { itmList.SubItems.Add(""); } else { itmList.SubItems.Add(DReader.GetString(j)); } } ltView.Items.Add(itmList); } return ltView; }