private void Form1_Load(object sender, EventArgs e)//加载部门名称 { try { string sql = @"SELECT [HouseID] ,[MovieHouse] FROM [movieDB].[dbo].[MovieHouse] GO"; movie = cc.QuerByAdapter(sql, "movie"); DataRow row = movie.Tables["movie"].NewRow(); row[0] = -1; row[1] = "请选择"; movie.Tables["movie"].Rows.InsertAt(row, 0); //添加到表的第一行位置 comboBox1.DisplayMember = "MovieHouse"; //显示的值 comboBox1.ValueMember = "HouseID"; //实际值 comboBox1.DataSource = movie.Tables["movie"]; string sql2 = @"SELECT [TicketId] ,[MovieName] ,Movie.[HouseID] ,[StartTime] ,[EndTime] ,[TicketPrice] ,[number] ,[MovieHouse] FROM [movieDB].[dbo].[Movie] inner join [movieDB].[dbo].[MovieHouse] on Movie.HouseID=MovieHouse.HouseID"; movie = cc.QuerByAdapter(sql2, "MovieList"); dv = new DataView(movie.Tables["MovieList"]); dataGridView1.DataSource = dv; } catch (Exception ex) { MessageBox.Show(ex.Message); } }
private void 影片列表_Load(object sender, EventArgs e) { string sql = @"SELECT [TicketId] ,[MovieName] ,[HouseID] ,[StartTime] ,[EndTime] ,[TicketPrice] ,[number] FROM [movieDB].[dbo].[Movie]"; DBTools dfg = new DBTools(); Moielist = dfg.QuerByAdapter(sql, "MovieList"); dataGridView1.DataSource = Moielist.Tables["MovieList"]; }