public void ListView_Accessor()
{
DataAccess.ES da=new DataAccess.ES();
SqlConnection conn=new SqlConnection();
conn=da.Connect();
conn.Open();
string myselect="select * from Xt";
SqlCommand cmd=new SqlCommand(myselect,conn);
SqlDataReader dr=cmd.ExecuteReader();
while(dr.Read())
{
ListViewItem lstViewItem=new ListViewItem();
lstViewItem.SubItems.Clear();
lstViewItem.SubItems.Add(dr["Xt_Type"].ToString());
lstViewItem.SubItems.Add(dr["Xt_Dif"].ToString());
lstViewItem.SubItems.Add(dr["Xt_Num"].ToString());
lstViewItem.SubItems.Add(dr["Xt_KName"].ToString());
this.listView1.Items.Add(lstViewItem);
}
conn.Close();
}
{
DataAccess.ES da=new DataAccess.ES();
SqlConnection conn=new SqlConnection();
conn=da.Connect();
conn.Open();
string myselect="select * from Xt";
SqlCommand cmd=new SqlCommand(myselect,conn);
SqlDataReader dr=cmd.ExecuteReader();
while(dr.Read())
{
ListViewItem lstViewItem=new ListViewItem();
lstViewItem.SubItems.Clear();
lstViewItem.SubItems.Add(dr["Xt_Type"].ToString());
lstViewItem.SubItems.Add(dr["Xt_Dif"].ToString());
lstViewItem.SubItems.Add(dr["Xt_Num"].ToString());
lstViewItem.SubItems.Add(dr["Xt_KName"].ToString());
this.listView1.Items.Add(lstViewItem);
}
conn.Close();
}