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();
}
}
