accp 4.0 二期毕业设计列车查询系统vs2005与sql200

//this.dataGridView2.Columns.Clear(); ConDB con = new ConDB(); //string sql = "select Train.TrainsCode as 车次,Train.StartCity as 始发站,Train.ArrivalCity as 终点站,Train.StartCity as 发站,Train.LeaveTime as 发车时间,Train.ArrivalCity as 到站,Train.ArrivalTime as 到站时间,Train.AirCondiction as 列车类型,Train.TrainSet as 硬座软座,TrainsInfo.Distance as 里程,TrainsInfo.Days as 历时,Train.Price as 票价 from Train inner join TrainsInfo on(Train.TrainsCode=TrainsInfo.TrainsCode)"; //ds = con.getsel(sql); //this.dataGridView2.DataSource = ds; //this.dataGridView2.DataMember = "TrainsInfo"; ds = con.getproc(); //this.dataGridView2.DataSource = ds.Tables[0]; ////this.dataGridView2.DataMember = "TrainsInfo"; //this.fpSpread1.DataSource = ds.Tables[0]; //this.dataGridView2.DataMember = "TrainsInfo"; //sqlcon = new SqlConnection("server=.;uid=sa;database=TrainTimeSelectSystem"); //string sql="select * from Train"; //da = new SqlDataAdapter(sql, sqlcon); //da.Fill(ds); //foreach (DataRow dw in ds.Tables[0].Rows) //{ // ListViewItem lstItem = new ListViewItem(); // lstItem.SubItems[0].Text = dw["TrainsCode"].ToString(); //第0列 // lstItem.SubItems.Add(dw["StartCity"].ToString());//第1列 // lstItem.SubItems.Add(dw["ArrivalCity"].ToString()); // lstItem.SubItems.Add(dw["TrainType"].ToString()); // lstItem.SubItems.Add(dw["LeaveTime"].ToString()); // lstItem.SubItems.Add(dw["ArrivalTime"].ToString()); // lstItem.SubItems.Add(dw["AirCondiction"].ToString()); // lstItem.SubItems.Add(dw["Speed"].ToString()); // lstItem.SubItems.Add(dw["Distance"].ToString()); // lstItem.SubItems.Add(dw["Days"].ToString()); // lstItem.SubItems.Add(dw["Price"].ToString()); // this.listView1.Items.Add(lstItem); //}