try
{
string sql = string.Format("select classId,loginId,studentName,studentNo,userState From student left join userstate on student.userstateId=userState.userStateId where student.StudentName like '%{0}%'", txtStudentName.Text.Trim());
SqlCommand command = new SqlCommand(sql, DBHelper.connection);
DBHelper.connection.Open(); //DBHelper为一个类
SqlDataReader dataReader = command.ExecuteReader();
lv.Items.Clear();
if (!dataReader.HasRows)
{
MessageBox.Show("没有找到您要查找的学生");
return;
}
string loginId;
string studentName;
string studentNo;
string userState;
while (dataReader.Read())
{
loginId = dataReader["loginId"].ToString();
studentName = dataReader["studentName"].ToString();
studentNo = dataReader["studentNo"].ToString();
userState = dataReader[4].ToString();
lv.Items.Add(lviStuden);
lviStuden.SubItems.AddRange(new string[] { studentName, studentNo, userState });
}
dataReader.Close();
}
catch (Exception ex)
{
MessageBox.Show("查询出错!");
}
finally
{
DBHelper.connection.Close();
}
{
string sql = string.Format("select classId,loginId,studentName,studentNo,userState From student left join userstate on student.userstateId=userState.userStateId where student.StudentName like '%{0}%'", txtStudentName.Text.Trim());
SqlCommand command = new SqlCommand(sql, DBHelper.connection);
DBHelper.connection.Open(); //DBHelper为一个类
SqlDataReader dataReader = command.ExecuteReader();
lv.Items.Clear();
if (!dataReader.HasRows)
{
MessageBox.Show("没有找到您要查找的学生");
return;
}
string loginId;
string studentName;
string studentNo;
string userState;
while (dataReader.Read())
{
loginId = dataReader["loginId"].ToString();
studentName = dataReader["studentName"].ToString();
studentNo = dataReader["studentNo"].ToString();
userState = dataReader[4].ToString();
ListViewItem lviStuden = new ListViewItem(loginId);
lviStuden.Tag = (int)dataReader["studentName"];lv.Items.Add(lviStuden);
lviStuden.SubItems.AddRange(new string[] { studentName, studentNo, userState });
}
dataReader.Close();
}
catch (Exception ex)
{
MessageBox.Show("查询出错!");
}
finally
{
DBHelper.connection.Close();
}