航空订票代码.docVIP

using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Linq; using System.Text; using System.Windows.Forms; using System.Data.SqlClient; namespace BookTickets { public partial class Tickets : Form { private DataSet ds = new DataSet(); private SqlDataAdapter sda; private void cx() { string s = string.Format(Select ID,FromCountry,ToCountry,FlyTime from AirLines where FromCountry like %{0}% and ToCountry like %{1}%, FromCountry.Text, ToCountry.Text); sda = new SqlDataAdapter(s, MyConnection.myconn); ds.Tables.Clear(); sda.Fill(ds, ticket); dataGridView1.DataSource = ds.Tables[ticket]; } public Tickets() { InitializeComponent(); } private void button1_Click(object sender, EventArgs e) { cx(); } private void Tickets_Load(object sender, EventArgs e) { cx(); } private void dataGridView1_MouseClick(object sender, MouseEventArgs e) { string ID = this.dataGridView1.SelectedRows[0].Cells[0].Value.ToString(); string chufadi, mudidi, chufashijian, jinjicang, toudengcang; try { MyConnection.myconn.Open(); string s = string.Format(select * from AirLines where ID={0} , ID); SqlCommand mycom = new SqlCommand(s, MyConnection.myconn); SqlDataReader sdr = mycom.ExecuteReader(); while (sdr.Read()) { chufadi = sdr[FromCountry].ToString(); mudidi = sdr[ToCountry].ToString(); chufashijian = sdr[FlyTime].ToString(); jinjicang = sdr[EconomyPrice].ToString(); toudengcang = sdr[FirstPrice].ToString(); cfd.Text = chufadi;