void GetScheme() { schobj = new Scheme_MP(ComObj); DataSet ds = schobj.selectAll(" order by Scheme_Id"); GridView1.DataSource = ds; GridView1.DataBind(); }
void GetScheme() { schobj = new Scheme_MP(ComObj); DataSet ds = schobj.selectAll("order by displayorder"); ddlscheme.DataSource = ds.Tables[0]; ddlscheme.DataTextField = "Scheme_Name"; ddlscheme.DataValueField = "Scheme_Id"; ddlscheme.DataBind(); // ddlscheme.Items.Insert(0, "--Select--"); }
void GetScheme() { schobj = new Scheme_MP(ComObj); DataSet ds = schobj.selectAll(" order by Scheme_Id"); ddlscheme.DataSource = ds.Tables[0]; ddlscheme.DataTextField = "Scheme_Name"; ddlscheme.DataValueField = "Scheme_Id"; ddlscheme.DataBind(); ddlscheme.Items.Insert(0, "--Select--"); ddlscheme.SelectedValue = "0"; ddlscheme.Enabled = false; }
void GetScheme() { if (con.State == ConnectionState.Closed) { con.Open(); } schobj = new Scheme_MP(ComObj); DataSet ds = schobj.selectAll(" order by Scheme_Id"); ddlscheme.DataSource = ds.Tables[0]; ddlscheme.DataTextField = "Scheme_Name"; ddlscheme.DataValueField = "Scheme_Id"; ddlscheme.DataBind(); if (con.State == ConnectionState.Open) { con.Close(); } }