Пример #1
0
    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;
            }
        }
    }