C#winform怎么读取数据库信息显示出来
我用了list view控件了
但是不知道代码有没有错 请告诉纠正一下或者详细教我下 只显示数据库3条信息而已 nvchar date money
private void listView1_SelectedIndexChanged(object sender, EventArgs e)
{
string connStr1 = "Data Source=.;Initial Catalog=Plane;Integrated Security=True";
SqlConnection conn1 = new SqlConnection(connStr1);
conn1.Open();
string sql1 = "select * from plane ";
SqlDataReader reader1 = null;
SqlCommand cmd1 = new SqlCommand(sql1, conn1);
reader1 = cmd1.ExecuteReader();
while (reader1.Read() )
{
string city=reader1["city"].ToString();
string time=(reader1["time"] + "\t");
string money=(reader1["money"] + "\t");
}
reader1.Close();