public void fillgrid()
{
DbConnect db = new DbConnect();
String qry = "select name,description,image_main from mainPackege";
DataSet ds = db.getData(qry);
gdvmain_pac.DataSource = ds.Tables["ss"];
gdvmain_pac.DataBind();
}
public void fillgrid()
{
DbConnect db = new DbConnect();
string subPackage = Session["subname"].ToString();
string query = "select d.Day_no,d.accomodation,d.description,days_image from days_ d,subPackege s where s.subPacge_Name='"+subPackage+"' and d.subPcgId=s.subPack_ID ";
DataSet ds = db.getData(query);
gdvdays.DataSource = ds.Tables["ss"];
gdvdays.DataBind();
}
public void fillgrid()
{
DbConnect db = new DbConnect();
string mainPackage = Session["name"].ToString();
string query = " select s.subPacge_Name ,s.noofdays,s.price from subPackege s,mainPackege p where s.packge_ID=p.package_id and p.name='" + mainPackage + "' ";
DataSet ds = db.getData(query);
gdvsubpac.DataSource = ds.Tables["ss"];
gdvsubpac.DataBind();
}
public void FillGrid()
{
DbConnect db = new DbConnect();
string qry = "select CustomerID,fname,lname,email from Customer";
DataSet ds=db.getData(qry);
GridEmail.DataSource = ds.Tables["ss"];
GridEmail.DataBind();
}
public void fillroomdetails()
{
DbConnect dc = new DbConnect();
string hotel = ddlHotelName.Text;
String qry = "select * from Hotels where hotelname = '" + ddlHotelName.Text + "' ";
DataTable dt = dc.select(qry); // rooms
if (dt != null && dt.Rows.Count != 0) //hotel details
{
txtAddress.Text = dt.Rows[0][2].ToString();
txtLocation.Text = dt.Rows[0][3].ToString();
txtDescription.Text = dt.Rows[0][4].ToString();
}
else
{
txtDescription.Text = "error occured";
}
String hotelId = dt.Rows[0][0].ToString();
String qry3 = "select RoomID,RoomNo,Roomtype,floor_num from room where hotelID = '" + hotelId + "' "; // room details
DataSet ds = dc.getData(qry3);
if (ds != null)
{
gvRoom.DataSource = ds.Tables["ss"];
gvRoom.DataBind();
}
String qry4 = "select HallID,Hall_Name,Hall_Type,NoOfSeats from Halls where HotelID='" + hotelId + "'";
DataSet ds2 = dc.getData(qry4); // halls
if (ds2 != null)
{
gvHalls.DataSource = ds2.Tables["ss"];
gvHalls.DataBind();
}
else
{
txtAddress.Text = "error";
}
}
public void fillGrid()
{
DbConnect dc = new DbConnect();
String MFillQuery = "select mr.rID,mr.date,mr.time, h.hall_Name,custID,hl.Hotelname,mp.price,mp.tableArrangement from MeetingReservation mr,Halls h,Hotels hl,Meeting mp where mr.hallID=h.HallID and h.hotelID=hl.hotelID and mp.hallID=h.HallID";
DataSet ds = dc.getData(MFillQuery);
if (ds == null)
{
bool b = false;
}
gv_meetingList.DataSource = ds.Tables["ss"];
gv_meetingList.DataBind();
}
// fill the grid view
public void fillGrid()
{
DbConnect dc = new DbConnect();
String qry = "select empid, fname , lname , address , email , Picture from employee";
DataSet ds = dc.getData(qry);
if (ds == null)
{
bool b = false;
}
gvReceptionist.DataSource = ds.Tables["ss"].DefaultView;
gvReceptionist.DataBind();
}
public void fillGrid()
{
DbConnect dc = new DbConnect();
// String customerFillQuery = "select c.ID, c.salutation,c.fname,c.lname,c.address,c.nationality,c.country,c.phone,c.email,c.passportNum from Customer c,WeddingReservation wr e where c.ID=wr.custID and wr.custID in (select wr.custID from WeddingReservation wr)";
String customerFillQuery = "select c.CustomerID, c.salutation,c.fname,c.lname,c.state_address,c.city,c.postelCode,c.country,c.phone,c.email,c.passport_NIC from Customer c,BanquetReservation wr where c.CustomerID=wr.custID and wr.custID in (select wr.custID from BanquetReservation wr)";
DataSet ds = dc.getData(customerFillQuery);
if (ds == null)
{
bool b = false;
}
gv_weddingCustomer.DataSource = ds.Tables["ss"];
gv_weddingCustomer.DataBind();
}
public void fillGrid()
{
DbConnect dc = new DbConnect();
String wedFillQuery = "select wr.RID,wr.date,wr.time,wr.themeColor,h.hall_name,custID,hl.hotelname,wp.price,wp.Decoration from BanquetReservation wr,Halls h,Hotels hl,Banquet wp where wr.hallID=h.hallID and h.hotelID=hl.hotelID and wp.hallID=h.hallID";
DataSet ds = dc.getData(wedFillQuery);
if (ds == null)
{
bool b = false;
}
gv_weddingList.DataSource = ds.Tables["ss"];
gv_weddingList.DataBind();
}
public void fillGrid()
{
DbConnect dc = new DbConnect();
String customerFillQuery = "select c.CustomerID, c.salutation,c.fname,c.lname,c.state_address,c.city,c.postelCode,c.country,c.phone,c.email,c.passport_NIC from Customer c,MeetingReservation mr where c.CustomerID=mr.custID and mr.custID in (select mr.custID from MeetingReservation mr)";
DataSet ds = dc.getData(customerFillQuery);
//what is done by this if condition
if (ds == null)
{
bool b = false;
}
gv_meetingCustomer.DataSource = ds.Tables["ss"];
gv_meetingCustomer.DataBind();
}