protected void LoadUserList() { this.lblStatusMsg.Text = ""; try { Commands cmd = new Commands(); DataTable dt = cmd.SelectUserList(0, "", "", "", "", "", "", 0, 2, 0, _UserID); GenUtilities.ClearDDLValues(this.ddlUserList, 1); this.ddlUserList.DataValueField = "UserID"; this.ddlUserList.DataTextField = "UserFullName3"; this.ddlUserList.DataSource = dt; this.ddlUserList.DataBind(); if (dt.Rows.Count == 0) { this.lblStatusMsg.Text = "No Users were found"; } } catch (Exception ex) { this.lblStatusMsg.Text = "Error encountered when loading user list: " + ex.Message; } }