用C#编的火车时刻表查询系统

来源：百度知道 编辑：UC知道 时间：2024/05/15 10:23:01
连接数据库的代码我看不懂，请高手指点，我没学过怎样和数据库连接，但我做的课程设计需要数据库。谢谢最好能详细点！
string str="select ScheduleCode,TrainType,fromCity,toCity,LeaveTime,ArrivalTime,Distance,Days from T_Schedule";
string str1="select * from T_Schedule_Detail";
SqlDataAdapter sda=new SqlDataAdapter();
sda.SelectCommand=new SqlCommand(str,con);
sda.Fill(ds,"T_Schedule");
sda.FillSchema(ds,SchemaType.Mapped);
SqlDataAdapter sda1=new SqlDataAdapter();
sda1.SelectCommand=new SqlCommand(str1,con);
sda1.Fill(ds,"T_Schedule_Detail");
sda1.FillSchema(ds,SchemaType.Mapped);
DataGridTableStyle dts = new DataGridTableStyle();
dts.MappingName = "T_Schedule";
this.dataGrid1.TableStyles.Add(dts);
DataGridTableStyle dts1= new DataGridTableStyle();
dts.MappingName = "T_Schedule_Detail";
this.dataGrid2.TableStyles

//查询语句，查询T_Schedule表中cheduleCode,TrainType,fromCity,toCity,LeaveTime,ArrivalTime,Distance,Days的内容
string str = "select ScheduleCode,TrainType,fromCity,toCity,LeaveTime,ArrivalTime,Distance,Days from T_Schedule";
//查询语句，查询T_Schedule_Detai表中的内容
string str1 = "select * from T_Schedule_Detail";
//实例化SqlDataAdapter
SqlDataAdapter sda = new SqlDataAdapter();
//执行查询语句str
sda.SelectCommand = new SqlCommand(str, con);
//将查到的结果放入dataset
sda.Fill(ds, "T_Schedule");
//将表结构放入dataset,Fill 加载数据本身，而 FillSchema 加载有关特定表的所有可用的元数据（如列名、主键和约束）SchemaType是个枚举
sda.FillSchema(ds, SchemaType.Mapped);
//实例化SqlDataAdapter
SqlDataAdapter sda1 = new SqlDataAdapter();
//执行查询语句str1
sda1.SelectCommand = new SqlCommand(str1, con);