private void LoadUserType()
{
List <UserTypeDetails> list = bluser.GetAllUserType();
UserTypeDetails utd = new UserTypeDetails();
utd.UserType = "Choose UserType";
list.Insert(0, utd);
cboUserType.DataSource = list;
cboUserType.DisplayMember = "UserType";
cboUserType.ValueMember = "UserType";
cboUserType.SelectedIndex = 0;
}
public List <UserTypeDetails> GetAllUserType()
{
List <UserTypeDetails> list = new List <UserTypeDetails>();
SqlConnection con = new SqlConnection("Data Source=PRASHISH\\SQLEXPRESS; Integrated Security=true; Database=BroadwayDB;");
SqlCommand cmd = new SqlCommand("SELECT tblUser.UserId, tblUser.Username, tblUser.Password, tblUserType.UserType FROM tblUser INNER JOIN tblUserType ON tblUser.UsertypeId = tblUserType.UserTypeId");
SqlDataReader dr = null;
dr = cmd.ExecuteReader();
while (dr.Read())
{
UserTypeDetails ud = new UserTypeDetails();
ud.UserTypeId = (int)dr["UserTypeId"];
ud.UserType = (string)dr["UserType"];
list.Add(ud);
}
dr.Close();
con.Close();
return(list);
}