public void fillMainTours()
 {
     dbCOnnect db = new dbCOnnect();
      String qry = "select description,image_main from mainPackege where name='" + ddmaintours_main.Text + "'";
      DataTable dt = db.selectIt(qry);
      txtdescription_main.Text = dt.Rows[0][0].ToString();
      image_main.ImageUrl = dt.Rows[0][1].ToString();
 }
 public void fillSubTours()
 {
     dbCOnnect db = new dbCOnnect();
      String qry = "select noofdays,price from subPackege where subPacge_Name='" + ddsubtour.Text + "'";
      DataTable dt = db.selectIt(qry);
      txtnoofdays.Text = dt.Rows[0][0].ToString();
      txtprice.Text = dt.Rows[0][1].ToString();
 }
 public void filldaysTours()
 {
     dbCOnnect db = new dbCOnnect();
      String qry = "select accomodation,description,days_image from days_ where day_no='" + ddday_no.Text + "'";
      DataTable dt = db.selectIt(qry);
      txtday_accomodation.Text = dt.Rows[0][0].ToString();
      txtdescription_days.Text = dt.Rows[0][1].ToString();
      image_day.ImageUrl = dt.Rows[0][2].ToString();
 }