kok电子竞技

121/121基于c#窗体的航空订票治理系统的设计与实现系统分工治理资料查询航线航空订票治理系统治理员用户修改公告修改航班治理资料查询航线航空订票治理系统治理员用户修改公告修改航班治理用户查看信息订票治理退票治理需求分析进入21世纪，人们计算机处理情况的需求有了进一步的要求。小到商店缴费治理系统的快速运行，大到国家航空航天计算机的治理系统的进一步提升。我们每时每刻都在追求着计算机处理情况的快速，稳定，运算量大等一系列优点。由于人们为了方便快捷的生活方式，上网差不多成为潮流，如此快速稳定的航空订票系统应运而生。航空订票系统需要满足一般的查询航线，订票，退票等一系列差不多操作，因此我们也能够设置黑名单，以屏蔽违规用户。因此人人都追求美感，那么系统界面的设计也要符合大众的审美要求。资料的安全与隐私性也是至关重要的，我们每个人，都不想不人明白自己的一些隐私，对自己资金的安全也格外重视。因此订票系统对不同的角色给予不同的权限从而保证用户资料的安全性与隐私性。系统功能（1）游客功能对游客我们系统只为其提供查询航班信息的功能，不可进行订票操作。当游客点击购票按钮时，将提醒其注册或登录。（2）用户注册用户只有注册成为我们的会员，才能够进行订票操作。一旦注册，用户名将不可修改。注册时不可与数据库中存在的用户名相同，即系统中只能存在唯一一个用户名。（3）用户中心提供用户对自己的资料的查看与修改的功能。还能够对自己的密码进行修改，在修改密码时需要输入原始密码进而进行验证。由于时刻问题，对个人钞票包功能先暂停使用，默认钞票够买票了。（4）订票功能用户可依照航班时刻，和航班号或航班价格进行订票。订票时系统会提醒确认，订票成功后系统会将用户的信息加入订票信息表。并改变航班的余票额。（5）退票功能用户在不需要票的情况下进行退票操作。退票时必须输入订票时随机生成的订单号，与航班号。退票成功后，航班自动将余票量加一操作。（6）本系统还添加了治理员界面。当治理员进入后，可对用户的信息进行查看，但不能修改，也可将用户加入黑名单，假如用户有订单，则不同意治理员做加入黑名单操作。因此加入黑名单时，治理员需要讲明理由，作为存档。治理员，也可依照实际情况对航班进行治理操作。增删改查。他也能够对公告进行修改操作。（7）系统也实现了，关于不同的角色进入，会产生不同的界面效果。保证了数据的安全性，和保密性。数据库设计（1）治理员表（2）航班表（3）黑名单表（4）订单信息表（5）用户信息表运行截图源代码usingSystem;usingSystem.Collections.Generic;usingSystem.Linq;usingSystem.Windows.Forms;namespace航空订票治理系统{staticclassProgram{///<summary>///应用程序的主入口点。///</summary>[STAThread]staticvoidMain(){stringdataDir=AppDomain.CurrentDomain.BaseDirectory;if(dataDir.EndsWith(@"\bin\Debug\")||dataDir.EndsWith(@"\bin\Release\")){dataDir=System.IO.Directory.GetParent(dataDir).Parent.Parent.FullName;AppDomain.CurrentDomain.SetData("DataDirectory",dataDir);}Application.EnableVisualStyles();Application.SetCompatibleTextRenderingDefault(false);Application.Run(newForm1());}}}usingSystem;usingSystem.Collections.Generic;usingSystem.ComponentModel;usingSystem.Data;usingSystem.Drawing;usingSystem.Linq;usingSystem.Text;usingSystem.Windows.Forms;usingSystem.Data.SqlClient;namespace航空订票治理系统{publicpartialclassForm1:Form{zhucezc=newzhuce();Userlaunchlch=newUserlaunch();publicstringstatus1{get;set;}intlabel1x;publicForm1(){InitializeComponent();}privatevoidForm1_Load(objectsender,EventArgse){label1x=label1.Right;timer1.Enabled=true;timer2.Enabled=true;timer3.Enabled=true;timer2.Start();novisible2();novisible1();textBox1.Focus();timer1.Start();}//隐藏治理员可做的操作publicvoidnovisible1(){客户信息ToolStripMenuItem.Visible=false;航班信息ToolStripMenuItem.Visible=false;修改公告ToolStripMenuItem.Visible=false;}//隐藏用户可做的操作publicvoidnovisible2(){用户补全资料ToolStripMenuItem.Visible=false;//个人中心用户充值ToolStripMenuItem.Visible=false;//办理业务}//隐藏登陆前界面publicvoidnovisible3(){用户登录ToolStripMenuItem.Visible=false;扫瞄信息ToolStripMenuItem.Visible=false;治理员登陆ToolStripMenuItem.Visible=false;}//操纵公告字段privatevoidtimer1_Tick(objectsender,EventArgse){label1.Location=newPoint(label1.Location.X-1,label1.Location.Y);if(label1.Right==0){label1.Left=label1x;}}//当点到按钮时，进行图片变换privatevoidbutton1_MouseEnter(objectsender,EventArgse){Buttonbttn;timer2.Enabled=false;bttn=(Button)sender;if(bttn==button1)picture1();elseif(bttn==button2)picture2();elseif(bttn==button3)picture3();elseif(bttn==button4)picture4();elseif(bttn==button5)picture5();}privatevoidradioButton1_CheckedChanged(objectsender,EventArgse){textBox5.Enabled=false;textBox1.Enabled=true;textBox2.Enabled=true;textBox5.Text="";textBox1.Focus();}privatevoidradioButton2_CheckedChanged(objectsender,EventArgse){textBox5.Enabled=true;textBox1.Text="";textBox2.Text="";textBox1.Enabled=false;textBox2.Enabled=false;}privatevoidradioButton4_CheckedChanged(objectsender,EventArgse){textBox6.Enabled=false;textBox3.Enabled=true;textBox4.Enabled=true;textBox6.Text="";textBox4.Focus();}privatevoidradioButton3_CheckedChanged(objectsender,EventArgse){textBox6.Enabled=true;textBox4.Text="";textBox3.Text="";textBox3.Enabled=false;textBox4.Enabled=false;textBox6.Focus();}//安全退出privatevoid用户退出ToolStripMenuItem_Click(objectsender,EventArgse){if(toolStripStatusLabel4.Text=="未登录"){MessageBox.Show("当前你未登录，请登录或注册");}else{MessageBox.Show(toolStripStatusLabel4.Text+"您已下线，感谢使用！");toolStripStatusLabel4.Text="未登录";status1="";novisible2();novisible1();用户登录ToolStripMenuItem.Visible=true;扫瞄信息ToolStripMenuItem.Visible=true;治理员登陆ToolStripMenuItem.Visible=true;}}//注册界面privatevoid扫瞄信息ToolStripMenuItem_Click(objectsender,EventArgse){zhucezc=newzhuce();zc.ShowDialog();}//图片变换privatevoidtimer2_Tick(objectsender,EventArgse){Randomrd=newRandom();intr=rd.Next(1,6);switch(r){case1:picture1();break;case2:picture2();break;case3:picture3();break;case4:picture4();break;case5:picture5();break;}}//图片显示方法privatevoidpicture1(){pictureBox1.Show();pictureBox2.Hide();pictureBox3.Hide();pictureBox4.Hide();pictureBox5.Hide();}privatevoidpicture2(){pictureBox2.Show();pictureBox1.Hide();pictureBox3.Hide();pictureBox4.Hide();pictureBox5.Hide();}privatevoidpicture3(){pictureBox3.Show();pictureBox2.Hide();pictureBox1.Hide();pictureBox4.Hide();pictureBox5.Hide();}privatevoidpicture4(){pictureBox4.Show();pictureBox2.Hide();pictureBox3.Hide();pictureBox1.Hide();}privatevoidpicture5(){pictureBox5.Show();pictureBox2.Hide();pictureBox3.Hide();pictureBox4.Hide();pictureBox1.Hide();}//当不用手动操纵图片时，执行privatevoidbutton1_MouseLeave(objectsender,EventArgse){timer2.Enabled=true;}//用户登陆privatevoid用户登录ToolStripMenuItem_Click(objectsender,EventArgse){Userlaunchuch=newUserlaunch();if(uch.ShowDialog()==DialogResult.OK){status1=uch.UserName;toolStripStatusLabel4.Text="尊敬的用户"+status1+"你好！";用户补全资料ToolStripMenuItem.Visible=true;用户充值ToolStripMenuItem.Visible=true;novisible1();novisible3();}uch.Dispose();}//治理员登陆privatevoid治理员登陆ToolStripMenuItem_Click(objectsender,EventArgse){Admainadn=newAdmain();if(adn.ShowDialog()==DialogResult.OK){toolStripStatusLabel4.Text=adn.AdmainName;novisible2();novisible3();客户信息ToolStripMenuItem.Visible=true;航班信息ToolStripMenuItem.Visible=true;修改公告ToolStripMenuItem.Visible=true;}}//机票预订privatevoidbutton6_Click(objectsender,EventArgse){if(toolStripStatusLabel4.Text=="未登录"){MessageBox.Show("请先登录");textBox1.Text=textBox2.Text=textBox5.Text="";}elseif(toolStripStatusLabel4.Text.Substring(0,3)=="友爱的"){MessageBox.Show("对不起，治理员，您不能订票的！");textBox1.Text=textBox2.Text=textBox5.Text="";}else{if(textBox1.Text!=""&&textBox2.Text!=""||textBox5.Text!=""){intn=1;jipiaoyudingjyd=newjipiaoyuding(textBox1.Text,textBox2.Text,textBox5.Text,n,status1);jyd.ShowDialog();}else{MessageBox.Show("对不起，你输入的信息不符合查询条件，请重新输入");}}}//系统时刻privatevoidtimer3_Tick(objectsender,EventArgse){this.toolStripStatusLabel3.Text="当前系统时刻："+DateTime.Now.ToString("yyyy-MM-ddhh:mm:ss");}//查询航班动态privatevoidbutton7_Click(objectsender,EventArgse){if(textBox4.Text!=""&&textBox3.Text!=""||textBox6.Text!=""){intn=2;jipiaoyudingjyd=newjipiaoyuding(textBox4.Text,textBox3.Text,textBox6.Text,n,status1);jyd.ShowDialog();textBox4.Text=textBox3.Text=textBox6.Text="";}else{MessageBox.Show("对不起，你输入的信息不符合查询条件，请重新输入");textBox4.Text=textBox3.Text=textBox6.Text="";}}privatevoid订票信息ToolStripMenuItem_Click(objectsender,EventArgse){订票信息dp=new订票信息();dp.ShowDialog();}privatevoid用户资料ToolStripMenuItem_Click(objectsender,EventArgse){用户资料yz=new用户资料();yz.ShowDialog();}privatevoid订票ToolStripMenuItem_Click(objectsender,EventArgse){jipiaoyudingjyd=newjipiaoyuding("","","",1,status1);jyd.ShowDialog();}privatevoid查询订单ToolStripMenuItem_Click(objectsender,EventArgse){个人订单gd=new个人订单(status1);gd.ShowDialog();}privatevoid黑名单资料ToolStripMenuItem_Click(objectsender,EventArgse){黑名单表hm=new黑名单表();hm.ShowDialog();}privatevoid航班信息ToolStripMenuItem_Click(objectsender,EventArgse){航班信息hbx=new航班信息();hbx.ShowDialog();}privatevoid修改公告ToolStripMenuItem_Click(objectsender,EventArgse){修改公告xg=new修改公告();if(xg.ShowDialog()==DialogResult.OK){label1.Text=xg.gonggao;}}privatevoid查看自己资料ToolStripMenuItem_Click(objectsender,EventArgse){个人资料gz=new个人资料(status1,1);gz.ShowDialog();}privatevoid修改个人资料ToolStripMenuItem_Click(objectsender,EventArgse){个人资料gz1=new个人资料(status1,2);gz1.ShowDialog();}privatevoid我想退票ToolStripMenuItem_Click(objectsender,EventArgse){退票系统tp=new退票系统(status1);if(tp.ShowDialog()==DialogResult.OK){MessageBox.Show("退票成功");}}privatevoidbutton8_Click(objectsender,EventArgse){if(toolStripStatusLabel4.Text=="未登录"){MessageBox.Show("你还未登陆，请先登录！");textBox7.Text=textBox8.Text=textBox9.Text="";textBox1.Focus();}elseif(toolStripStatusLabel4.Text.Substring(0,3)=="友爱的"){MessageBox.Show("治理员，您是无权退票的。");textBox7.Text=textBox8.Text=textBox9.Text="";textBox1.Focus();}else{退票系统tp=new退票系统(status1);tp.tuibiao(textBox7.Text,textBox8.Text,textBox9.Text);{if(tp.DialogResult==DialogResult.OK){MessageBox.Show("退票成功");}}}}//取消退票privatevoidbutton9_Click(objectsender,EventArgse){textBox7.Text=textBox8.Text=textBox9.Text="";textBox7.Focus();}}}usingSystem;usingSystem.Collections.Generic;usingSystem.ComponentModel;usingSystem.Data;usingSystem.Drawing;usingSystem.Linq;usingSystem.Text;usingSystem.Windows.Forms;usingSystem.Data.SqlClient;namespace航空订票治理系统{publicpartialclasszhuce:Form{publicstringUsername{get;set;}publicstringUserpassword1{get;set;}publicstringUserpassword2{get;set;}publicintflag1,flag2,flag3;stringconnectionString=Properties.Settings.Default.HKDPConnectionString;publiczhuce(){InitializeComponent();flag1=1;flag2=1;flag3=1;toolTip1.InitialDelay=0;toolTip1.ReshowDelay=0;toolTip1.SetToolTip(textBox1,"用户名不能超过20个字符，而且只能用字母，数字!");toolTip1.SetToolTip(textBox2,"密码不能少于6个子");toolTip1.SetToolTip(textBox3,"请再输入一次密码");errorProvider1.BlinkStyle=ErrorBlinkStyle.NeverBlink;}privatevoidbutton2_Click(objectsender,EventArgse){this.Dispose();}//验证密码是否大于6个字符privatevoidtextBox2_TextChanged(objectsender,EventArgse){if(textBox2.Text.Length<=6||textBox2.Text.Length>20){errorProvider2.SetError(textBox2,"密码非法！");flag1=0;}else{errorProvider2.Clear();flag1=1;}}//验证用户名是否大于6个字符，同时必须是数字和字母的组合privatevoidtextBox1_Enter(objectsender,EventArgse){intflag=1;for(inti=0;i<textBox1.Text.Length;i++){if(char.IsLetterOrDigit(textBox1.Text[i])==false){flag=0;}else{flag=1;}}if(textBox1.Text.Length<=6||textBox1.Text.Length>20||flag==0){errorProvider1.SetError(textBox1,"用户名非法！");flag2=0;}else{errorProvider1.Clear();flag2=1;}}//验证确认密码是否正确privatevoidtextBox3_TextChanged(objectsender,EventArgse){if(textBox3.Text!=textBox2.Text||textBox3.Text.Length<=6){errorProvider3.SetError(textBox3,"密码非法！");flag3=0;}else{errorProvider3.Clear();flag3=1;}}/*开始添加数据*/privatevoidbutton1_Click(objectsender,EventArgse){Username=textBox1.Text;Userpassword1=textBox2.Text;using(SqlConnectionconn=newSqlConnection(connectionString)){conn.Open();try{if(flag1==1&&flag2==1&&flag3==1&&textBox2.Text==textBox3.Text){SqlCommandcmd=newSqlCommand();cmd.Connection=conn;SqlDataAdapteradapter=newSqlDataAdapter("select*fromUsertablewhereUsername='"+textBox1.Text+"'",conn);DataTabletable=newDataTable();adapter.Fill(table);if(table.Rows.Count==0){cmd.CommandText="insertintoUsertable(Username,Upassword)values(@Username,@Username)";cmd.Parameters.Clear();cmd.Parameters.Add(newSqlParameter("Username",Username));cmd.Parameters.Add(newSqlParameter("Upassword",Userpassword1));cmd.ExecuteNonQuery();conn.Close();MessageBox.Show("恭喜您，注册成功");this.Dispose();}else{MessageBox.Show("对不起，此用户名已被注册！");textBox1.Text=textBox2.Text=textBox3.Text="";textBox1.Focus();flag1=1;}}else{MessageBox.Show("专门遗憾，差一步就完成了！");textBox1.Text=textBox2.Text=textBox3.Text="";textBox1.Focus();flag1=1;}}catch(Exceptionerr){MessageBox.Show(err.Message);}}}}}usingSystem;usingSystem.Collections.Generic;usingSystem.ComponentModel;usingSystem.Data;usingSystem.Drawing;usingSystem.Linq;usingSystem.Text;usingSystem.Windows.Forms;usingSystem.Data.SqlClient;namespace航空订票治理系统{publicpartialclassUserlaunch:Form{publicstringUserName{get;set;}stringconnection=Properties.Settings.Default.HKDPConnectionString;publicUserlaunch(){InitializeComponent();}//登陆开始privatevoidbutton1_Click(objectsender,EventArgse){try{SqlConnectionconn=newSqlConnection(connection);conn.Open();SqlCommandcmd=newSqlCommand();cmd.Connection=conn;cmd.CommandText="selectcount(*)fromUsertablewhereUsername='"+textBox1.Text+"'andUpassword='"+textBox2.Text+"'";if((int)cmd.ExecuteScalar()==1){UserName=textBox1.Text;this.DialogResult=DialogResult.OK;}else{MessageBox.Show("登录名或密码错误！请重新输入");textBox1.Text="";textBox2.Text="";textBox1.Focus();}conn.Close();}catch(Exceptionerr){MessageBox.Show(err.Message);}}//关闭窗体privatevoidbutton2_Click(objectsender,EventArgse){this.Dispose();}}}usingSystem;usingSystem.Collections.Generic;usingSystem.ComponentModel;usingSystem.Data;usingSystem.Drawing;usingSystem.Linq;usingSystem.Text;usingSystem.Windows.Forms;usingSystem.Data.SqlClient;namespace航空订票治理系统{publicpartialclassAdmain:Form{publicstringAdmainName{get;set;}stringconnection=Properties.Settings.Default.HKDPConnectionString;publicAdmain(){InitializeComponent();}//释放窗体privatevoidbutton2_Click(objectsender,EventArgse){this.Dispose();}//进入密码验证privatevoidbutton1_Click(objectsender,EventArgse){try{SqlConnectionconn=newSqlConnection(connection);conn.Open();SqlCommandcmd=newSqlCommand();cmd.Connection=conn;cmd.CommandText="selectcount(*)fromAdmainwhereAdmainId='"+textBox1.Text+"'andApassword='"+textBox2.Text+"'";if((int)cmd.ExecuteScalar()==1){AdmainName="友爱的治理员"+textBox1.Text+"你好！";this.DialogResult=DialogResult.OK;}else{MessageBox.Show("登录名或密码错误！请重新输入");textBox1.Text="";textBox2.Text="";textBox1.Focus();}conn.Close();}catch(Exceptionerr){MessageBox.Show(err.Message);}}}}usingSystem;usingSystem.Collections.Generic;usingSystem.ComponentModel;usingSystem.Data;usingSystem.Drawing;usingSystem.Linq;usingSystem.Text;usingSystem.Windows.Forms;usingSystem.Data.SqlClient;namespace航空订票治理系统{publicpartialclassjipiaoyuding:Form{SqlDataAdapteradapter;DataTabletable;publicstringusername{get;set;}intQ;stringconnectionString=Properties.Settings.Default.HKDPConnectionString;publicjipiaoyuding(){InitializeComponent();dataGridView1.SelectionMode=DataGridViewSelectionMode.FullRowSelect;}//在主窗体中指定的条件筛选出来的数据publicjipiaoyuding(stringa,stringb,stringc,intn,stringq){InitializeComponent();dataGridView1.SelectionMode=DataGridViewSelectionMode.FullRowSelect;Q=n;username=q;try{SqlConnectionconn=newSqlConnection(connectionString);if(c==""){conn.Open();adapter=newSqlDataAdapter("select*fromHangbanwherechufadi='"+a+"'anddaodadi='"+b+"'",conn);table=newDataTable();adapter.Fill(table);dataGridView1.DataSource=table;head();conn.Close();}else{conn.Open();adapter=newSqlDataAdapter("select*fromHangbanwhereHBid='"+c+"'",conn);table=newDataTable();adapter.Fill(table);dataGridView1.DataSource=table;head();conn.Close();}}catch(Exceptionerr){MessageBox.Show(err.Message);}}//释放此窗体privatevoidbutton2_Click(objectsender,EventArgse){this.Dispose();}//筛选指定航班的值privatevoidtextBox1_TextChanged(objectsender,EventArgse){SqlConnectionconn=newSqlConnection(connectionString);conn.Open();adapter=newSqlDataAdapter("select*fromHangbanwhereHBid='"+textBox1.Text+"'",conn);table=newDataTable();adapter.Fill(table);dataGridView1.DataSource=table;head();conn.Close();}//筛选符合大于一个价格privatevoidtextBox2_TextChanged(objectsender,EventArgse){try{SqlConnectionconn=newSqlConnection(connectionString);conn.Open();adapter=newSqlDataAdapter("select*fromHangbanwhereprice>="+textBox2.Text,conn);table=newDataTable();adapter.Fill(table);dataGridView1.DataSource=table;head();conn.Close();}catch(Exceptionerr){MessageBox.Show("看起来出错了，请重新筛选"+err.Message);}}//筛选小于一个价格的值privatevoidtextBox3_TextChanged(objectsender,EventArgse){try{SqlConnectionconn=newSqlConnection(connectionString);conn.Open();adapter=newSqlDataAdapter("select*fromHangbanwhereprice<="+textBox3.Text,conn);table=newDataTable();adapter.Fill(table);dataGridView1.DataSource=table;head();conn.Close();}catch(Exceptionerr){MessageBox.Show("看起来出错了，请重新筛选"+err.Message);}}//订票开始privatevoidbutton1_Click(objectsender,EventArgse){if(MessageBox.Show("确定要订票吗？","提示",MessageBoxButtons.YesNo,MessageBoxIcon.Warning)==DialogResult.Yes){try{if(Q==1){SqlConnectionconn=newSqlConnection(connectionString);conn.Open();SqlCommandcmd=newSqlCommand("updateHangbansetsyps=syps-1whereHBid='"+dataGridView1.SelectedRows[0].Cells[0].Value.ToString()+"'",conn);cmd.ExecuteNonQuery();intx=int.Parse(dataGridView1.SelectedRows[0].Cells[8].Value.ToString());inty=int.Parse(dataGridView1.SelectedRows[0].Cells[7].Value.ToString());stringHban=dataGridView1.SelectedRows[0].Cells[0].Value.ToString();decimalPrice=decimal.Parse(dataGridView1.SelectedRows[0].Cells[6].Value.ToString());if(x==0){cmd.Connection=conn;cmd.CommandText="updateHangbansetsyps=syps+1whereHBid='"+dataGridView1.SelectedRows[0].Cells[0].Value.ToString()+"'";cmd.ExecuteNonQuery();MessageBox.Show("对不起，没有票啦！请定其他航班");}else{MessageBox.Show("购买成功,你的座位号是："+(y-x+1).ToString());xierushuju(username,y-x+1,Hban,Price);this.Dispose();}conn.Close();}else{MessageBox.Show("对不起，你现在查询航班状态！不能预订，现在带你回登陆界面。");this.Dispose();}}catch(Exceptionerr){MessageBox.Show("看起来出错了。。。"+err.Message);}}}//添加订票信息publicvoidxierushuju(stringunm,inty,stringHban,decimalPrice){SqlConnectionconn=newSqlConnection(connectionString);conn.Open();SqlCommandcmd=newSqlCommand("insertintoInfo(Username,HBid,prices,zuoweihao)values('"+unm+"','"+Hban+"',"+Price.ToString()+","+y.ToString()+")",conn);cmd.ExecuteNonQuery();}//修改表头标题privatevoidhead(){dataGridView1.Columns["HBid"].HeaderText="订单编号";dataGridView1.Columns["chufadi"].HeaderText="动身地";dataGridView1.Columns["daodadi"].HeaderText="到达地";dataGridView1.Columns["Startdate"].HeaderText="动身日期";dataGridView1.Columns["Enddate"].HeaderText="到达日期";dataGridView1.Columns["weekdays"].HeaderText="星期";dataGridView1.Columns["price"].HeaderText="机票价格";dataGridView1.Columns["contents"].HeaderText="额定人数";dataGridView1.Columns["syps"].HeaderText="余票数量";}}}usingSystem;usingSystem.Collections.Generic;usingSystem.ComponentModel;usingSystem.Data;usingSystem.Drawing;usingSystem.Linq;usingSystem.Text;usingSystem.Windows.Forms;usingSystem.Data.SqlClient;namespace航空订票治理系统{publicpartialclass订票信息:Form{stringconnection=Properties.Settings.Default.HKDPConnectionString;SqlDataAdapteradapter;DataTabletable;public订票信息(){InitializeComponent();}privatevoid订票信息_Load(objectsender,EventArgse){try{dataGridView1.SelectionMode=DataGridViewSelectionMode.FullRowSelect;SqlConnectionconn=newSqlConnection(connection);conn.Open();adapter=newSqlDataAdapter("select*fromInfo",conn);table=newDataTable();adapter.Fill(table);dataGridView1.DataSource=table;dataGridView1.Columns["ddhao"].HeaderText="订单编号";dataGridView1.Columns["Username"].HeaderText="用户名";dataGridView1.Columns["HBid"].HeaderText="航班编号";dataGridView1.Columns["prices"].HeaderText="航班价格";dataGridView1.Columns["zuoweihao"].HeaderText="座位号";conn.Close();}catch(Exceptionerr){MessageBox.Show("看起来出错了。。。"+err.Message);}}}}usingSystem;usingSystem.Collections.Generic;usingSystem.ComponentModel;usingSystem.Data;usingSystem.Drawing;usingSystem.Linq;usingSystem.Text;usingSystem.Windows.Forms;usingSystem.D