整體的首頁

//創建配適器
        SqlDataAdapter sa;
        //創建臨時數據集
        DataSet ds;
        public FrmLogin()
        {
            InitializeComponent();
        }

        private void dataGridView1_CellContentClick(object sender, DataGridViewCellEventArgs e)
        {
            //創建連接對象
            SqlConnection conn = new SqlConnection(DBHelper.str);
        }

        private void FrmLogin_Load(object sender, EventArgs e)
        {
            //調用出發地的顯示信息
            add();
            //調用到達目的地的顯示信息
            Goto();
        }
        /// <summary>
        /// 顯示出發地的信息
        /// </summary>
        public void add()
        {
            //連接對象
            SqlConnection conn = new SqlConnection(DBHelper.str);
            //拼接sql語句
            string sql = "select * from CityInfo";
            //適配器
            sa = new SqlDataAdapter(sql, conn);
            //創建數據集字符串
            ds = new DataSet();
            //填充數據集

            sa.Fill(ds);
            //向數據集和中添加文字
            //Tables獲取包含DataSet中的集合
            DataRow row = ds.Tables[0].NewRow();
            row["Id"] = -1;
            row["CityName"] = "請選擇";
            ds.Tables[0].Rows.InsertAt(row, 0);
            //獲取或者設置文本框的數據源
            cmbGo.DataSource = ds.Tables[0];
            //顯示屬性
            cmbGo.DisplayMember = "CityName";
            //真實屬性
            cmbGo.ValueMember = "Id";
            cmbGo.DataSource = ds.Tables[0];//綁定數據源
        }

        /// <summary>
        /// 顯示目的地的信息
        /// </summary>
        public void Goto()
        {
            //連接對象
            SqlConnection conn = new SqlConnection(DBHelper.str);
            //拼接sql語句
            string sql = "select * from CityInfo";
            //適配器
            sa = new SqlDataAdapter(sql, conn);
            //創建數據集字符串
            ds = new DataSet();
            //填充數據集

            sa.Fill(ds);
            //向數據集和中添加文字
            //Tables獲取包含DataSet中的集合
            DataRow row = ds.Tables[0].NewRow();
            row["Id"] = -1;
            row["CityName"] = "請選擇";
            ds.Tables[0].Rows.InsertAt(row, 0);
            //獲取或者設置文本框的數據源
            cmbBourn.DataSource = ds.Tables[0];
            //顯示屬性
            cmbBourn.DisplayMember = "CityName";
            //真實屬性
            cmbBourn.ValueMember = "Id";
            cmbBourn.DataSource = ds.Tables[0];//綁定數據源
        }
        /// <summary>
        /// 查詢按鈕把數據庫的信息顯示到DataGridView中
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void btnRefer_Click(object sender, EventArgs e)
        {
            //創建連接對象
            SqlConnection conn = new SqlConnection(DBHelper.str);
            try
            {
                int grade = Convert.ToInt32(cmbBourn.SelectedValue);
                int grade1 = Convert.ToInt32(cmbGo.SelectedValue);
                //拼接sql語句
                string sql = @"select f.FlightNO,a.Airways,f.LeaveTime,f.LandTime,f.Price 
               from FlightInfo as f,AirwaysInfo as a 
               where f.AirwaysId = a.Id and f.LeaveCity ='" + grade + "' and f.Destination = '" + grade1 + "'";

                ds = new DataSet();
                sa = new SqlDataAdapter(sql, conn);
                sa.Fill(ds);//填充數據
                dataGridView1.DataSource = ds.Tables[0];//綁定數據源
            }
                
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
                
            }
        }



        /// <summary>
        /// 將單元格的值顯示在文本框中
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void dataGridView1_CellContentClick_1(object sender, DataGridViewCellEventArgs e)
        {
            dataGridView1.AutoGenerateColumns = false;
            //在第二個分組框顯示信息
            //拿到當前選中項的航班號
            string Flightnum = Convert.ToString(dataGridView1.SelectedRows[0].Cells[0].Value);            //航空公司
            string Airways = Convert.ToString(dataGridView1.SelectedRows[0].Cells[1].Value);
            //出發時間
            string LeaveTime = Convert.ToString(dataGridView1.SelectedRows[0].Cells[2].Value);
            //到達時間
            string LandTime = Convert.ToString(dataGridView1.SelectedRows[0].Cells[3].Value);
            //成人票價
            string Price = Convert.ToString(dataGridView1.SelectedRows[0].Cells[4].Value);
            //出發地
            string formCity = cmbGo.Text;
            //目的地
            string toidCity = cmbBourn.Text;
            //賦值給第二個分組框text文本框各個值
            txtNo.Text = Flightnum.ToString();
            textBox2.Text = Airways;
            txtTime.Text = LeaveTime;
            txtG.Text = LandTime;
            txtfares.Text = Price.ToString();
            textBox3.Text = formCity;
            txtDd.Text = toidCity;


        }






        /// <summary>
        /// 實現航班預定功能
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void btnreserve_Click(object sender, EventArgs e)
        {
            //創建對象的連接
            SqlConnection conn = new SqlConnection(DBHelper.str);
            //獲取時間
            string date = dateTimePicker1.Value.ToString();
            //獲取隨機數
            Random dom = new Random();
            int num = dom.Next(10000, 10000000);
            try
            {
                //打開數據庫
                conn.Open();

                //時間間隔的比較
                if (DateTime.Now > dateTimePicker1.Value)
                {
                    MessageBox.Show("請i選擇正確的出發時間！");

                }
                else
                {

                    //拼接sql語句
                    string sql = "insert into OrderInfo ([OrderId],[FlightNo],[LeaveDate],[Number]) VALUES ('" + num + "','" + textBox2 + "','" + txtTime.Text + "','" + txtfares.Text + "')";

                    SqlCommand cmd = new SqlCommand(sql, conn);
                    int Ex = cmd.ExecuteNonQuery();


                    if (Ex > 0)
                    {
                        MessageBox.Show("預定成功！訂單編號為：" + num);
                    }
                    else
                    {
                        MessageBox.Show("添加失敗！");
                    }
                }
               
               
                

            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);

            }
            finally
            {
                conn.Close();
            }
        }







錯誤的提示語：

總結

以上是生活随笔為你收集整理的开发“航班查询及预定”系统的全部內容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網站內容還不錯，歡迎將生活随笔推薦給好友。