C# ListView空间

string sql = string.Format("select * from water where type='{0}'",CboLB.Text);
SqlCommand comm = new SqlCommand(sql, con);
con.Open();
SqlDataReader re = comm.ExecuteReader();
if (re.HasRows)
{
LvSPCX.Items.Clear();
while (re.Read())
{
ListViewItem lv = new ListViewItem(new string[] { re["name"].ToString(), re["type"].ToString(), re["number"].ToString(), re["price"].ToString() });
LvSPCX.Items.Add(lv);
}
}

你不要第一列就改string sql = string.Format("select * from water where type='{0}'",CboLB.Text); 把*改为你要的数据列就行了

listview.item[i][j]表示第i列第j行的元素，大概就是这个思路