Exemple #1
0
        private void FillUserSearchGrid()
        {
            try {
                grdUserResults.DataSource = null;
                grdUserResults.DataBind();

                string login    = txtUserSearchLogin.Text;
                int    roleID   = 0;
                bool   inActive = chkUserSearchShowInActive.Checked;

                if (ddlUserSearchRole.SelectedIndex > 0)
                {
                    roleID = Convert.ToInt32(ddlUserSearchRole.SelectedItem.Value);
                }

                using (SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["BeetConn"].ToString())) {
                    using (SqlDataReader dr = WSCSecurity.SecurityRoleGetUsers(conn, login, roleID, inActive)) {
                        grdUserResults.DataSource = dr;
                        grdUserResults.DataBind();
                    }
                }

                if (grdUserResults.Rows.Count == 1)
                {
                    grdUserResults.SelectedIndex = 0;
                    FillEditArea();
                }
                else
                {
                    if (grdUserResults.SelectedRow != null)
                    {
                        FillEditArea();
                    }
                }
            }
            catch (Exception ex) {
                Common.CException wex = new Common.CException("Security.FillUserSearchGrid", ex);
                throw (wex);
            }
        }