q_1037327746的博客

一个简单的winform项目 Hotel(); Foods(); Travel(); KTV(); if (this.cb_Type.Text == "全部类型") { //创建链接对像 SqlConnection Conn = new SqlConnection(DBHelper.ConnectionString); //打开连接 Conn.Open(); //执行sql语句 string sqlStr = "select * from Product"; //创建命令对象 SqlCommand cmd = new SqlCommand(sqlStr, Conn); //执行命令 SqlDataReader reader = cmd.ExecuteReader(); //读取 this.listView1.Items.Clear(); while (reader.Read()) { ListViewItem item = new ListViewItem(reader["ProductID"].ToString()); item.SubItems.Add(reader["ProductName"].ToString()); item.SubItems.Add(reader["ProductPrice"].ToString()); this.listView1.Items.Add(item); } reader.Close(); //关闭 Conn.Close(); }