Listview 先load 进去数据,若定义个获得Sql语句的方法,getsql(),和filllist()方法,查找里调用这两个方法后查找出来的数据就显示在load数据的后面,load进去的数据有清屏的方法吗?
写了listView items.clear()方法加在filllist()方法里,
编译的时候报错:“System.Windows.Forms.ListView.ListViewItemCollection”并不包含“clear”的定义.请问clear.如何定义?
fillList()方法 public void FillList( string sql)
{
try
{
SqlCommand command = new SqlCommand(sql,DBHelper.connection);
DBHelper.connection.Open();
SqlDataReader reader = command.ExecuteReader();
lvStudent.Items.clear();
while (reader.Read())
{
int id = Convert.ToInt32(reader["StudentID"]);
string name = Convert.ToString(reader["Name"]);
string className = Convert.ToString(reader["ClassName"]);
string sex = Convert.ToString(reader["sex"]);
string address = Convert.ToString(reader["Address"]);
string teacher = Convert.ToString(reader["Teacher"]); ListViewItem item = new ListViewItem(name);
item.Tag = id;
item.SubItems.AddRange(new string[] { className, sex, address, teacher});
lvStudent.Items.Add(item);
}
reader.Close();
}
catch(Exception ex)
{
MessageBox.Show(ex.Message);
}
finally
{
DBHelper.connection.Close();
}
}谢谢!
写了listView items.clear()方法加在filllist()方法里,
编译的时候报错:“System.Windows.Forms.ListView.ListViewItemCollection”并不包含“clear”的定义.请问clear.如何定义?
fillList()方法 public void FillList( string sql)
{
try
{
SqlCommand command = new SqlCommand(sql,DBHelper.connection);
DBHelper.connection.Open();
SqlDataReader reader = command.ExecuteReader();
lvStudent.Items.clear();
while (reader.Read())
{
int id = Convert.ToInt32(reader["StudentID"]);
string name = Convert.ToString(reader["Name"]);
string className = Convert.ToString(reader["ClassName"]);
string sex = Convert.ToString(reader["sex"]);
string address = Convert.ToString(reader["Address"]);
string teacher = Convert.ToString(reader["Teacher"]); ListViewItem item = new ListViewItem(name);
item.Tag = id;
item.SubItems.AddRange(new string[] { className, sex, address, teacher});
lvStudent.Items.Add(item);
}
reader.Close();
}
catch(Exception ex)
{
MessageBox.Show(ex.Message);
}
finally
{
DBHelper.connection.Close();
}
}谢谢!
datasource=null