private void FillListView()
{
string id; //id號(hào)
string loginName ; // 用戶名
string password ; // 密碼
string status; // 狀態(tài)
string name; // 姓名
string gender; // 性別
string phone; // 電話
string email; // 電子郵件
string address;
string grade; // 年級(jí)
string sClass; // 班級(jí)
string createTime; // 創(chuàng)建時(shí)間
string updateTime; //修改時(shí)間
string remark; // 備注
try
{
// 構(gòu)建sql
string sql = "SELECT ID,login_name,PASSWORD,status,name,gender,phone,email,address,grade,class,is_using,to_char(create_time,'yyyy-mm-dd hh24:mi') createTime,to_char(update_time,'yyyy-mm-dd hh24:mi') updateTime,remark FROM t_vs_student ";
if (this.txtSearchName.Text.Trim() != "")
{
sql += string.Format(" where name like '%{0}%'", this.txtSearchName.Text.Trim());
}
OracleCommand command = new OracleCommand(sql, DBHelper.connection);
DBHelper.connection.Open();
OracleDataReader dataReader = command.ExecuteReader();
// 清除列表項(xiàng)
this.lvStudent.Items.Clear();
// 檢查dataReader沒有數(shù)據(jù)
if (!dataReader.HasRows)
{
MessageBox.Show("沒有找到您要找的用戶", "結(jié)果提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
while (dataReader.Read())
{
id = dataReader["id"].ToString();
loginName = dataReader["login_name"].ToString();
password = dataReader["password"].ToString();
status = dataReader["status"].ToString();
name = dataReader["name"].ToString();
gender = dataReader["gender"].ToString();
phone = dataReader["phone"].ToString();
email = dataReader["email"].ToString();
address = dataReader["address"].ToString();
grade = dataReader["grade"].ToString();
sClass = dataReader["class"].ToString();
createTime = dataReader["createTime"].ToString();
updateTime = dataReader["updateTime"].ToString();
remark = dataReader["remark"].ToString();
//loginName = (string)dataReader.Read("login_name");
// 創(chuàng)建列表選項(xiàng)
ListViewItem lviStudent = new ListViewItem(loginName);
// 這個(gè)值不要用戶看，但是對(duì)程序員有用
//lviStudent.Tag = id;
// 添加一行
this.lvStudent.Items.Add(lviStudent);
// 添加行數(shù)據(jù)
lviStudent.SubItems.AddRange(new string[] {name, gender, phone, email, address, grade, sClass,createTime,updateTime,remark});
}
dataReader.Close();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
finally
{
DBHelper.connection.Close();
}
}