C#代码如下
怎么样修改 可以显示所有包含的
然后 查询相同ID的不重复显示
string xingming = "", yonghuming = "", studentno = "";
int userstateid;
if (txtUserName.Text == "")
{
MessageBox.Show("请输入用户名");
txtUserName.Focus();
}
else
{
string sql = string.Format("select loginid,studentname,studentno,userstateid from student where loginid like '%{0}%'", txtUserName.Text);
SqlCommand command = new SqlCommand(sql, DBHelper.connection);
DBHelper.connection.Open();
SqlDataReader datareader = command.ExecuteReader();
while (datareader.Read())
{
yonghuming = (string)datareader["loginid"];
xingming = (string)datareader["studentname"];
studentno = (string)datareader["studentno"];
userstateid = (int)datareader["userstateid"];
}
lvStudent.Items.Add(new ListViewItem(new string[] { yonghuming, xingming,studentno}));
}
DBHelper.connection.Close();
}