邮件查看与操作小系统-自己做的

try { DBHelp.conn.Open(); //构建查询命令 SqlCommand command = new SqlCommand(sql, DBHelp.conn); SqlDataReader reader = command.ExecuteReader(); //循环从数据库中读出数据添加到ListView中 while (reader.Read()) { //从数据库中读取 Receiver = (string)reader["Receiver"]; Acceptor=(string)reader["Acceptor"]; Subject = (string)reader["Subject"]; Data=Convert.ToString(reader["Data"]); //构建选项 ListViewItem item = new ListViewItem(Receiver); //主要项 item.Tag = (int)reader["ID"]; lvShow.Items.Add(item); //for (int i = 1; i < reader.FieldCount; i++) //{ // item.SubItems.Add(new string[] { Re }); //} //this.lvShow.Items.Add(item); //添加子选项 item.SubItems.AddRange(new string[] {Acceptor,Subject,Data}); } reader.Close();