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