void GetScheme()
{
schobj = new Scheme_MP(ComObj);
DataSet ds = schobj.selectAll(" order by Scheme_Id");
GridView1.DataSource = ds;
GridView1.DataBind();
}
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);
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);
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--");
}
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();
}
}
