public void GetMemberDetail(int MemberId)
        {
            dbProcedures db = new dbProcedures();
            System.Data.SqlClient.SqlDataReader reader;

            reader = db.GetMemberDetail(MemberId);

            try
            {
                if (reader.Read())
                {
                    if ((!object.ReferenceEquals(reader[0], System.DBNull.Value)))
                    {
                        lblMemberId.Text = reader[0].ToString();

                        txtUsername.Text = reader[1].ToString();
                        txtPassword.Text = reader[2].ToString();
                        cbInvalidPassword.Checked = Convert.ToBoolean(reader[3].ToString());
                        cbInactive.Checked = Convert.ToBoolean(reader[4].ToString());
                        txtFirstName.Text = reader[5].ToString();
                        txtLastName.Text = reader[6].ToString();

                        txtCarrier.Items.Add(new ListItem("Blue Shield CA", "BlueShieldCA"));
                        txtCarrier.Items.Add(new ListItem("Anthem", "Anthem"));
                        txtCarrier.SelectedValue = reader[7].ToString();

                        txtEmployerGroup.Text = reader[8].ToString();
                        lblCreationTS.Text = reader[9].ToString();
                        lblUpdatedTS.Text = reader[10].ToString();

                    }
                    else
                    {
                        lblMemberId.Text = "Error retrieving member detail.";

                        btnDelete.Visible = false;
                        btnUpdate.Visible = false;
                    }
                }
            }
            catch (Exception e)
            {
                lblMemberId.Text = "Error retrieving member detail.";
                btnDelete.Visible = false;
                btnUpdate.Visible = false;
            }

            reader.Close();
            db.Close();
        }