private void button2_Click(object sender, EventArgs e)
{
try
{
OleDbConnectionStringBuilder connectStringBuilder = new OleDbConnectionStringBuilder();
connectStringBuilder.DataSource = @"F:\火车站售票系统\mydata\trainsail.mdb";
connectStringBuilder.Provider = "Microsoft.Jet.OLEDB.4.0"; using (OleDbConnection cn = new OleDbConnection(connectStringBuilder.ConnectionString))
{
DataSet ds = new DataSet();
OleDbCommand cmdLiming = new OleDbCommand("SELECT [all].checi, [all].name AS 始发站, [all].arrtime AS 到站时间1, [all].starttime AS 发车时间1, all1.name AS 目的站, all1.arrtime AS 到站时间2, all1.starttime AS 发车时间2FROM ([all] INNER JOIN all1 ON [all].checi = all1.checi) WHERE ([all].name = '北京') AND (all1.name = '丰润') ", cn); cn.Open(); using (OleDbDataReader drLiming = cmdLiming.ExecuteReader())
{
ds.Load(drLiming, LoadOption.OverwriteChanges, new string[] { "all" }); // 将 BindingSource 组件绑定至 DataSet 当中的“车次”数据表。
this.bindingSource1.DataSource = ds.Tables["all"]; // 将 DataGridView 控件绑定至 BindingSource 组件。
this.dataGridView1.DataSource = this.bindingSource1;
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "请注意", MessageBoxButtons.OK, MessageBoxIcon.Stop);
} }红的部分,怎么根据上面的SQL语句,连接,那两个表,新手,麻烦指教下,谢谢了。
{
try
{
OleDbConnectionStringBuilder connectStringBuilder = new OleDbConnectionStringBuilder();
connectStringBuilder.DataSource = @"F:\火车站售票系统\mydata\trainsail.mdb";
connectStringBuilder.Provider = "Microsoft.Jet.OLEDB.4.0"; using (OleDbConnection cn = new OleDbConnection(connectStringBuilder.ConnectionString))
{
DataSet ds = new DataSet();
OleDbCommand cmdLiming = new OleDbCommand("SELECT [all].checi, [all].name AS 始发站, [all].arrtime AS 到站时间1, [all].starttime AS 发车时间1, all1.name AS 目的站, all1.arrtime AS 到站时间2, all1.starttime AS 发车时间2FROM ([all] INNER JOIN all1 ON [all].checi = all1.checi) WHERE ([all].name = '北京') AND (all1.name = '丰润') ", cn); cn.Open(); using (OleDbDataReader drLiming = cmdLiming.ExecuteReader())
{
ds.Load(drLiming, LoadOption.OverwriteChanges, new string[] { "all" }); // 将 BindingSource 组件绑定至 DataSet 当中的“车次”数据表。
this.bindingSource1.DataSource = ds.Tables["all"]; // 将 DataGridView 控件绑定至 BindingSource 组件。
this.dataGridView1.DataSource = this.bindingSource1;
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "请注意", MessageBoxButtons.OK, MessageBoxIcon.Stop);
} }红的部分,怎么根据上面的SQL语句,连接,那两个表,新手,麻烦指教下,谢谢了。
--可在查询分析器中调试
--LZ将左联查询和子查询搞混了
SELECT a.checi, a.name AS 始发站, a.arrtime AS 到站时间1,
a.starttime AS 发车时间1, b.name AS 目的站, b.arrtime AS 到站时间2,
b.starttime AS 发车时间2
FROM ([all] a, all1 b
where a.checi = b.checi and a.name = '北京' AND b.name = '丰润'