读书人

为甚么下面代码在listview内显示不了数

发布时间: 2012-06-01 16:46:36 作者: rapoo

为甚么下面代码在listview内显示不了数据库内容!各位大仙帮帮忙啊?

public Form1()
{
SqlCommand sqlCommand;
SqlConnection sqlConnection;

string cn = "Server=ELVIS-PC;Initial Catalog=学生管理数据库; User ID=sa; Password=12345";
sqlConnection=new SqlConnection(cn);
string sql= "select * from 学生表 ";
sqlCommand=new SqlCommand(sql,sqlConnection);
sqlConnection.Open();

DataSet ds = new DataSet();
SqlDataAdapter da = new SqlDataAdapter(sql, sqlConnection);
SqlCommandBuilder cb = new SqlCommandBuilder(da);
da.Fill(ds);
try
{


// ListViewItem[] l = new ListViewItem[ds.Tables[0].Rows.Count];


ListViewItem l = null;

foreach (DataRow row in ds.Tables[0].Rows)
{


l = new ListViewItem(row["学号"].ToString());
l.SubItems.Add(row["姓名"].ToString());

l.SubItems.Add(row["性别"].ToString());
l.SubItems.Add(row["年龄"].ToString());
l.SubItems.Add(row["系别"].ToString());
l.SubItems.Add(row["班级"].ToString());
listView1.Items.Add(l);

}
}
catch
{
}








InitializeComponent();

}




}
}


[解决办法]

探讨

首先看你读取数据成功没?
在看你的绑定代码有没问题

[解决办法]
如果只是读,可以这样
public Form1()
{
SqlCommand sqlCommand;
SqlConnection sqlConnection;

string cn = "Server=ELVIS-PC;Initial Catalog=学生管理数据库; User ID=sa; Password=12345";
sqlConnection=new SqlConnection(cn);
string sql= "select * from 学生表 ";
sqlCommand=new SqlCommand(sql,sqlConnection);
sqlConnection.Open();
SqlDataReader jr = sqlCommand.ExecuteReader();
while (jr.Read() == true)
{
item = listView1.Items.Add(jr[0].ToString());

item.SubItems.Add(jr[1].ToString());
item.SubItems.Add(jr[2].ToString());
item.SubItems.Add(jr[3].ToString());
item.SubItems.Add(jr[4].ToString());
item.SubItems.Add(jr[5].ToString());
}
jr.Close();
sqlConnection.Close();

读书人网 >C#

热点推荐