public DataSet GetDetails() { String query = "select * from tblbooking"; DataSet ds = dbobj.getRecord(query); return(ds); }
protected void Page_Load(object sender, EventArgs e) { if (Session["Email"] == null) { Response.Redirect("HomePage.aspx"); } bool pagepost = this.IsPostBack; if (pagepost == false) { clscar obj = new clscar(); string query = "select * from tblcarcat"; try { DataSet ds = dbobj.getRecord(query); ddlCarCat.DataSource = ds.Tables[0]; ddlCarCat.DataTextField = "CarCatName"; ddlCarCat.DataValueField = "CarCatID"; ddlCarCat.DataBind(); ddlCarCat.Items.Insert(0, new ListItem("Select", String.Empty)); } catch (Exception err) { lblmsg.Text = err.Message; } } }