// Form Load Methos
#region
private void GetFormLoadData(int orgID)
{
ds = objBAL.GetDocument(orgID);
if (ds.Tables.Count > 0)
{
GrdDocumnet.DataSource = ds.Tables[0];
GrdDocumnet.DataBind();
}
else
{
GrdDocumnet.DataSource = null;
GrdDocumnet.DataBind();
}
ds.Clear();
ds = objBAL.SelectData(orgID);
txtFormNo.Text = DDL_SelectCollege.SelectedValue + "/" + ds.Tables[0].Rows[0][0].ToString();
//txt_UserName.Text = lbl_ApplicationId.Text;
objEWA.OrgID = orgID;
ds = objBAL.BL_BindCourse(objEWA);
ddlCourse.DataSource = ds;
ddlCourse.DataTextField = "CourseName";
ddlCourse.DataValueField = "CourseId";
ddlCourse.DataBind();
ddlCourse.Items.Insert(0, "Select Course");
ds.Clear();
// Bind Cast Categoty To DropDown
ds = objBAL.BindCasteCategory_BL(objEWA);
cn.Open();
SqlCommand cmd = new SqlCommand("SELECT CasteCategoryId,CasteCategoryName FROM tblCasteCategory where OrgId='" + orgID.ToString() + "'", cn);
SqlDataReader dr = cmd.ExecuteReader();
// ddlcountry.DataSource = dr;
ddlCaste.DataSource = dr;
ddlCaste.DataTextField = "CasteCategoryName";
ddlCaste.DataValueField = "CasteCategoryId";
ddlCaste.DataBind();
ddlCaste.Items.Insert(0, "Select");
dr.Close();
//SqlCommand cmd1 = new SqlCommand("SELECT CasteCategoryId,CasteCategoryName FROM tblCasteCategory where OrgId='" + orgID.ToString() + "'", cn);
//SqlDataReader dr1 = cmd1.ExecuteReader();
//ddlFeeCategory.DataSource = dr1;
//ddlFeeCategory.DataTextField = "CasteCategoryName";
//ddlFeeCategory.DataValueField = "CasteCategoryId";
//ddlFeeCategory.DataBind();
//ddlFeeCategory.Items.Insert(0, "Select");
//ds = new DataSet();
//ds.ReadXml(Server.MapPath("AddressXMLFile.xml"));
//ViewState["DatasetAll"] = ds;
//LoadCountryDropDown();
}
// Form Load Methos
#region
private void GetFormLoadData(int orgID)
{
ds = objBAL.SelectData(orgID);
lbl_ApplicationId.Text = Session["OrgId"] + "/" + ds.Tables[0].Rows[0][0].ToString();
txt_UserName.Text = lbl_ApplicationId.Text;
objEWA.OrgID = orgID;
ds = objBAL.BL_BindCourse(objEWA);
ddl_Course.DataSource = ds;
ddl_Course.DataTextField = "CourseName";
ddl_Course.DataValueField = "CourseId";
ddl_Course.DataBind();
ddl_Course.Items.Insert(0, "Select");
ds.Clear();
// Bind Cast Categoty To DropDown
ds = objBAL.BindCasteCategory_BL(objEWA);
ddl_CasteCategory.DataSource = ds;
ddl_CasteCategory.DataTextField = "CasteCategoryName";
ddl_CasteCategory.DataValueField = "CasteCategoryId";
ddl_CasteCategory.DataBind();
ddl_CasteCategory.Items.Insert(0, "Select");
ddl_Caste.DataSource = ds;
ddl_Caste.DataTextField = "CasteCategoryName";
ddl_Caste.DataValueField = "CasteCategoryId";
ddl_Caste.DataBind();
ddl_Caste.Items.Insert(0, "Select");
ds = objBAL.BindSportName();
DDL_Sports.DataSource = ds;
DDL_Sports.DataTextField = "SportName";
DDL_Sports.DataValueField = "SportId";
DDL_Sports.DataBind();
DDL_Sports.Items.Insert(0, new ListItem("Select", "-1"));
DDL_Sports.Items.Insert(1, new ListItem("N/A", "0"));
ds = new DataSet();
ds.ReadXml(Server.MapPath("AddressXMLFile.xml"));
ViewState["DatasetAll"] = ds;
LoadCountryDropDown();
}