#region listview 所有listview导入数据
public void lvwkpi(ListView listview1, string sqlstrlvw)
{
SqlCommand sqlcmd = this.getcom(sqlstrlvw);
SqlDataReader sdr = sqlcmd.ExecuteReader();
listview1.Items.Clear();
while (sdr.Read())
{
ListViewItem lvt = new ListViewItem();
lvt.SubItems.Clear();
lvt.SubItems[0].Text = sdr.GetValue(0).ToString();
int j = listview1.Columns.Count;//获得listview的总列数
for (int i = 1; i < j; i++)
{
lvt.SubItems.Add(sdr.GetValue(i).ToString());
}
listview1.Items.Add(lvt);
}
sqlcmd.Dispose();
sdr.Close();
}
public void lvwkpi(ListView listview1, string sqlstrlvw)
{
SqlCommand sqlcmd = this.getcom(sqlstrlvw);
SqlDataReader sdr = sqlcmd.ExecuteReader();
listview1.Items.Clear();
while (sdr.Read())
{
ListViewItem lvt = new ListViewItem();
lvt.SubItems.Clear();
lvt.SubItems[0].Text = sdr.GetValue(0).ToString();
int j = listview1.Columns.Count;//获得listview的总列数
for (int i = 1; i < j; i++)
{
lvt.SubItems.Add(sdr.GetValue(i).ToString());
}
listview1.Items.Add(lvt);
}
sqlcmd.Dispose();
sdr.Close();
}