protected void BindUserType() { try { DataTable dt = new DataTable(); string Query = "select UserTypeId,Type from Com_UserType_Mst where ActiveStatus =1"; dt = com.executeSqlQry(Query); if (dt != null && dt.Rows.Count > 0) { DdlUserType.DataSource = dt; DdlUserType.DataTextField = "Type"; DdlUserType.DataValueField = "UserTypeId"; DdlUserType.DataBind(); for (int i = 0; i < dt.Rows.Count; i++) { //Modified by satish on 10-July-13 if (dt.Rows[i]["Type"].ToString() == "Normal") { DdlUserType.SelectedValue = dt.Rows[i]["UserTypeId"].ToString(); break; } } } } catch { } }
private void DisplayUserType() { using (var context = new PnpLoanEntities()) { DdlUserType.DataSource = context.UserTypes.ToList(); DdlUserType.DataValueField = "UserTypeId"; DdlUserType.DataTextField = "Description"; DdlUserType.DataBind(); } }