private void ListInfo(string SQL)
{
ConnHelper.Sqlconn.connOpen();
this.listView.Items.Clear();
SqlDataAdapte da=new SqlDataAdapter(SQL,ConnHelper.Sqlconn.conn);
DataTable dt=new DataTable();
da.Fill(dt);
ConnHelper.Sqlconn.connClose();
foreach(DataRow dr in dt.Rows)
{
ListViewItem lv;
lv=new ListViewItem(dr[0].ToString());重要
lv.SubItems.Add(dr[1].ToString());
lv.SubItems.Add(dr[2].ToString());
this.listView.Items.Add(lv);
}
}
定义一个高效字符串
stringBuilder sbSql=new StringBuilder();
sbSql.Append("select login_id,login_name,login_pwd from tb_login");
ListInfo(sbSql.ToString());