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();
}