void GetSchemeCS() { schobj = new Scheme_MP(ComObj); string comd = "SELECT * FROM dbo.tbl_MetaData_SCHEME order by Scheme_Id"; DataSet ds = schobj.selectAny(comd); GridView2.DataSource = ds; GridView2.DataBind(); GridView2.Columns[1].Visible = false; }
void GetScheme() { schobj = new Scheme_MP(ComObj); string qrysch = "Select * from dbo.tbl_MetaData_SCHEME order by Scheme_Id "; DataSet ds = schobj.selectAny(qrysch); ddlscheme.DataSource = ds.Tables[0]; ddlscheme.DataTextField = "Scheme_Name"; ddlscheme.DataValueField = "Scheme_Id"; ddlscheme.DataBind(); ddlscheme.Items.Insert(0, "--Select--"); }
void GetSchemeDCP() { schobj = new Scheme_MP(ComObj); string qryDCP = "SELECT * FROM dbo.tbl_MetaData_SCHEME where Scheme_Id not in(1,2,3)and Status='Y' order by Scheme_Id "; DataSet ds = schobj.selectAny(qryDCP); ddldcpscheme.DataSource = ds.Tables[0]; ddldcpscheme.DataTextField = "Scheme_Name"; ddldcpscheme.DataValueField = "Scheme_Id"; ddldcpscheme.DataBind(); ddldcpscheme.Items.Insert(0, "--Select--"); }
void GetScheme() { schobj = new Scheme_MP(ComObj); string qrySC = "SELECT * FROM dbo.tbl_MetaData_DCP_S order by Scheme_Id "; DataSet ds = schobj.selectAny(qrySC); ddlscheme.DataSource = ds.Tables[0]; ddlscheme.DataTextField = "Scheme_Name"; ddlscheme.DataValueField = "Scheme_Id"; ddlscheme.DataBind(); ddlscheme.Items.Insert(0, "--Select--"); }