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"];
}
