ADO.NET CRUD OPERATION 2 Tier

#region Used NamesSpaces
using System;
using System.Collections.Generic;
using System.Linq;
using System.Threading.Tasks;
using System.Windows.Forms;
using WindowsFormsApplication.mini.Components;#endregion

namespace WindowsFormsApplication.mini
{
    public class Program
    {
        /// <summary>
        /// The main entry point for the application.
        /// </summary>
        ///
        [STAThread]
        static void Main()
        {
            Application.EnableVisualStyles();
            Application.SetCompatibleTextRenderingDefault(false);
            Application.Run(new MembershipManager());
        }
    }
}

#region Used Namespaces
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Data;
using System.Data.SqlClient;
#endregion Used Namespaces
namespace WindowsFormsApplication.mini.Components
{
    class HealthClubDbConnection
    {
        #region Public Properties
        /// <summary>
        /// Connection string property
        /// </summary>
        public static string constring {get;set;}
        #endregion Public Properties
        #region Methods
        #region GetDbConnection
        /// <summary>
        /// To establish DataBase Connection...
        /// </summary>
        /// <returns>SqlConnection object</returns>

        public static SqlConnection GetDbConnection()
        {
            SqlConnection conHealthClub;
            constring = "Data Source=EL-WS14\\SQLEXPRESS;Initial Catalog=dbs_HealthClubMemberManagement;Integrated Security=True";
            conHealthClub = new SqlConnection(constring);
            return conHealthClub;
        }
        #endregion GetDbConnection
        #endregion Methods
    }
}
#endregion Copyright

#region Used Namespaces
using System;
using System.Collections.Generic;
using System.Linq;
using System.Drawing;
using System.ComponentModel;
using System.Windows.Forms;
using System.Text;
using System.Threading.Tasks;
using System.Data;
using System.Data.SqlClient;
using WindowsFormsApplication.mini.Components;
using System.Collections;
#endregion Used Namespaces
namespace WindowsFormsApplication.mini.Components
{
    class LoginMember
    {
        #region Public Properties
        /// <summary>
        ///username of logged in user
        /// </summary>
        public string Username {get;set;}
        /// <summary>
        /// password of logged in user
        /// </summary>
        public string Password {get;set;}
        #endregion Public Properties
        #region Methods
        #region ValidateLogin
        /// <summary>
        /// Authentication ,If Username and Password Are Correct ;Login
        /// </summary>
        ///
        public bool ValidateLogin()
        {
            string loginquery;
            SqlDataReader dbr;

            SqlConnection conHealthClub = null;
            bool result = false;
            SqlCommand cmd;

            try
            {
                int count = 0;
                loginquery = "SELECT log_username,log_password from hea_login ";
                loginquery += "where log_username=@user and log_password = @pass";

                conHealthClub = HealthClubDbConnection.GetDbConnection();
                conHealthClub.Open();

                cmd = new SqlCommand(loginquery, conHealthClub);

                SqlParameter sqlparam1 = cmd.Parameters.AddWithValue("@user", Username);
                SqlParameter SqlParam2 = cmd.Parameters.AddWithValue("@Pass", Password);
                cmd.ExecuteNonQuery();
                dbr = cmd.ExecuteReader();

                while (dbr.Read())
                {
                    count = count + 1;
                }

                if (count == 1)
                {
                    result = true;
                }
                else
                {
                    result = false;
                }

            }
            catch (Exception es)
            {
                MessageBox.Show(es.Message);
            }
            finally
            {
                conHealthClub.Close();
            }
            return result;
        }#endregion ValidateLogin
        #endregion Methods
    }
}

#region Used Namespaces
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Data;
using System.Data.SqlClient;
using System.Windows.Forms;
using WindowsFormsApplication.mini.Components;
#endregion Used Namespaces
namespace WindowsFormsApplication.mini.Components
{
    class Member
    {
        #region Properties
        /// <summary>
        /// memberid of new member
        /// </summary>
        public int MemberId {get;set;}
        /// <summary>
        /// name if new member
        /// </summary>
        public string Name {get;set;}
        /// <summary>
        /// date of birth of new member
        /// </summary>
        public DateTime DateofBirth {get;set;}
        /// <summary>
        /// occupation of new member
        /// </summary>
        public string Occupation {get;set;}
        /// <summary>
        /// salary of new member
        /// </summary>
        public double Salary {get;set;}
        /// <summary>
        /// marital status of new member
        /// </summary>
        public string Martialstatus {get;set;}
        /// <summary>
        /// health status of new member
        /// </summary>
        public string Healthstatus {get;set;}
        /// <summary>
        /// no of children of new member
        /// </summary>
        public int ChildrenNumber {get;set;}
        #endregion Properties
        #region Methods
        #region GetAllMembers
        /// <summary>
        /// To Get All Members From Member table in the database
        /// </summary>
        /// <returns>dataset of members</returns>
        public DataSet GetAllMembers()
        {
            SqlDataAdapter daMembers;

            SqlConnection conObj = null;
            DataSet dsMembers = null;

            try
            {
                string selectQuery = "SELECT mem_memberid,mem_name,mem_dateofbirth,mem_occupation,mem_salary,";
                selectQuery += "mem_martialstatus,mem_healthstatus,mem_noofchildren FROM hea_member";

                conObj = HealthClubDbConnection.GetDbConnection();
                conObj.Open();

                daMembers = new SqlDataAdapter(selectQuery, conObj);
                dsMembers = new DataSet();
                daMembers.Fill(dsMembers);
            }
            catch (Exception es)
            {
                throw es;
            }
            finally
            {
                conObj.Close();
            }

            return dsMembers;
        }#endregion GetAllMembers
        #region CheckExistingMember
        /// <summary>
        /// Method to check whether the Member is existing
        /// </summary>
        /// <returns>true/false</returns>
        public bool CheckExistingMember()
        {
            string selectQuery;
            SqlCommand cmdSelect;
            SqlDataReader drSelect;
            SqlConnection cObj = null;
            int count = 0;
            bool result = false;
            try
            {
                selectQuery = "SELECT mem_name,mem_dateofbirth from hea_member where mem_name=@namepass and mem_dateofbirth = @Datepass";

                cObj = HealthClubDbConnection.GetDbConnection();
                cObj.Open();

                cmdSelect = new SqlCommand(selectQuery, cObj);
                SqlParameter sqlparam8 = cmdSelect.Parameters.AddWithValue("@namepass", Name);
                SqlParameter SqlParam9 = cmdSelect.Parameters.AddWithValue("@Datepass", DateofBirth);
                drSelect = cmdSelect.ExecuteReader();

                while (drSelect.Read())
                {
                    count = count + 1;
                }

                if (count > 0)
                {
                    result = true;
                }
                else
                {
                    result = false;
                }
            }
            catch (SqlException ex)
            {
                throw ex;
            } finally
            {
                cObj.Close();
            }
            return result;
        }
        #endregion CheckExistingMember
        #region InsertAMember
        /// <summary>
        /// To Insert A Member Into Database
        /// </summary>
        /// <returns>true/false</returns>
        public bool InsertAMember()
        {
            string insertQuery;
            SqlCommand cmdInsert;
            int rowsAffected;
            SqlConnection cObj = null;
            bool result = false;
            bool isexists = false;

            try
            {
                isexists = CheckExistingMember();
                if (!isexists)
                {
                    insertQuery = "insert into hea_member values(@Name,@DOB,@Occupation,@Salary,";
                    insertQuery += "@MartialStatus,@HealthStatus,@NoOfChildren )";

                    cObj = HealthClubDbConnection.GetDbConnection();
                    cObj.Open();

                    cmdInsert = new SqlCommand(insertQuery, cObj);
                    cmdInsert.Connection = cObj;

                    SqlParameter SqlParam1 = cmdInsert.Parameters.AddWithValue("@Name", Name);
                    SqlParameter SqlParam2 = cmdInsert.Parameters.AddWithValue("@DOB", DateofBirth);
                    SqlParameter SqlParam3 = cmdInsert.Parameters.AddWithValue("@Occupation", Occupation);
                    SqlParameter SqlParam4 = cmdInsert.Parameters.AddWithValue("@Salary", Salary);
                    SqlParameter SqlParam5 = cmdInsert.Parameters.AddWithValue("@MartialStatus", Martialstatus);
                    SqlParameter SqlParam6 = cmdInsert.Parameters.AddWithValue("@HealthStatus", Healthstatus);
                    SqlParameter SqlParam7 = cmdInsert.Parameters.AddWithValue("@NoOfChildren", ChildrenNumber);
                    rowsAffected = cmdInsert.ExecuteNonQuery();

                    if (rowsAffected > 0)
                    {
                        result = true;
                    }
                    else
                    {
                        result = false;
                    }
                }
                else
                {
                    result = false;
                }
            }
            catch (Exception es)
            {
                throw es;
            }
            finally
            {
                cObj.Close();
            }
            return result;
        }
        #endregion InsertMembers
        #region UpdateAMember
        /// <summary>
        /// To Update An Existing Member
        /// </summary>
        public bool UpdateAMember()
        {
            string updateQuery;
            int rowsAffected;
            SqlCommand cmdUpdate;

            SqlConnection conobj = null;
            bool result = false;

            try
            {
                updateQuery = "update hea_member set mem_name=@name,mem_dateofbirth=@DOB,mem_occupation=@Occupation,";
                updateQuery += "mem_salary=@Salary,mem_martialstatus=@MartialStatus,mem_healthstatus=@HealthStatus,";
                updateQuery += "mem_noofchildren=@NoOfChildren where mem_memberid=@id";

                conobj = HealthClubDbConnection.GetDbConnection();
                conobj.Open();

                cmdUpdate = new SqlCommand(updateQuery, conobj);
                cmdUpdate.Connection = conobj;

                SqlParameter sqlparam1 = cmdUpdate.Parameters.AddWithValue("@id", MemberId);
                SqlParameter SqlParam2 = cmdUpdate.Parameters.AddWithValue("@Name", Name);
                SqlParameter SqlParam3 = cmdUpdate.Parameters.AddWithValue("@DOB", DateofBirth);
                SqlParameter SqlParam4 = cmdUpdate.Parameters.AddWithValue("@Occupation", Occupation);
                SqlParameter SqlParam5 = cmdUpdate.Parameters.AddWithValue("@Salary", Salary);
                SqlParameter SqlParam6 = cmdUpdate.Parameters.AddWithValue("@MartialStatus", Martialstatus);
                SqlParameter SqlParam7 = cmdUpdate.Parameters.AddWithValue("@HealthStatus", Healthstatus);
                SqlParameter SqlParam8 = cmdUpdate.Parameters.AddWithValue("@NoOfChildren", ChildrenNumber);
                rowsAffected = cmdUpdate.ExecuteNonQuery();

                if (rowsAffected > 0)
                {
                    result = true;
                }
                else
                {
                    result = false;
                }
            }
            catch (Exception es)
            {
                throw es;
            }
            finally
            {
                conobj.Close();
            }
            return result;
        }
        #endregion UpdateAMember
        #region DeleteAMember
        /// <summary>
        /// To Delete A Member From Database
        /// </summary>
        /// <param name="memberIdToDelete">the member id selected to delete(int)</param>
        /// <returns>true/false</returns>
        public bool DeleteAMember(int memberIdToDelete)
        {
            string deleteQuery;
            SqlCommand cmdDelete;
            int rowsAffected;

            SqlConnection conobj = null;
            bool result = false;

            try
            {
                deleteQuery = "delete hea_member where mem_memberid=@id";

                conobj = HealthClubDbConnection.GetDbConnection();
                cmdDelete = new SqlCommand(deleteQuery, conobj);
                conobj.Open();
                cmdDelete.Connection = conobj;

                SqlParameter sqlparam1 = cmdDelete.Parameters.AddWithValue("@id", memberIdToDelete);
                rowsAffected = cmdDelete.ExecuteNonQuery();

                if (rowsAffected > 0)
                {
                    result = true;
                }
                else
                {
                    result = false;
                }

            }
            catch (Exception es)
            {
                throw es;
            }
            finally
            {
                conobj.Close();
            }
            return result;
        }
        #endregion DeleteMember
        #region Search Member
        /// <summary>
        /// To Search Members ,By Occupation And Marital Status
        /// </summary>
        /// <param name="oper">the operator to be used in the search query (and/or)</param>
        /// <returns>Dataset of members matching the search query</returns>
        public DataSet Search(string oper)
        {
            SqlCommand cmdSearch;
            SqlDataAdapter daSearch;
            string searchQuery;

            SqlConnection conobj = null;
            DataSet ds = null;

            try
            {
                searchQuery = "SELECT mem_memberid,mem_name,mem_dateofbirth,mem_occupation,mem_salary,mem_martialstatus,mem_healthstatus,mem_noofchildren FROM hea_member where mem_occupation=@Occupation " + oper + " mem_martialstatus=@MartialStatus ";

                conobj = HealthClubDbConnection.GetDbConnection();
                conobj.Open();
                cmdSearch = new SqlCommand(searchQuery, conobj);

                SqlParameter SqlParam1 = cmdSearch.Parameters.AddWithValue("@Occupation", Occupation);
                SqlParameter SqlParam2 = cmdSearch.Parameters.AddWithValue("@MartialStatus", Martialstatus);
                daSearch = new SqlDataAdapter(cmdSearch);
                ds = new DataSet();
                daSearch.Fill(ds);
            }
            catch (Exception es)
            {
                throw es;
            }
            finally
            {
                conobj.Close();
            }
            return ds;
        }
    }
    #endregion Search Member
    #endregion Methods
}

#region Used Namespaces
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;
using System.Data.SqlClient;
using System.Configuration;
using.WindowsFormsApplication.mini.Components;
#endregion Used Namespace
namespace.WindowsFormsApplication.mini
{
    public partial class SocialLogin: Form
    {
        public SocialLogin()
        {
            InitializeComponent();
        }
        private void HealthClubMemberManagement_Load(object sender, EventArgs e)
        {
        }
        private void lblUsername_Click(object sender, EventArgs e)
        {
        }
        #region Login Button Click Event
        /// <summary>
        /// Enable Login If UserName And PassWord Are Correct
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void btnLogin_Click(object sender, EventArgs e)
        {
            bool result;
            if (!(txtUsername.Text == string.Empty))
            {
                if (!(txtPassword.Text == string.Empty))
                {
                    LoginMember logobj = new LoginMember();
                    logobj.Username = txtUsername.Text;
                    logobj.Password = txtPassword.Text;

                    result = logobj.ValidateLogin();

                    if (result == true)
                    {
                        MembershipManager newregobj = new MembershipManager();
                        newregobj.Show();
                    }
                    else
                    {
                        MessageBox.Show(" username and password incorrect");
                    }
                }
                else
                {
                    MessageBox.Show("Please Enter Password");
                }
            }
            else
            {
                MessageBox.Show("Please Enter Username");
            }
        }
        #endregion Login Button Click Event
        #region onload
        private void frmSocialLogin_Load(object sender, EventArgs e) {
        }
        #endregion onload
    }
}

#region Used NameSpaces
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;
using System.Data.SqlClient;
using System.Configuration;
using System.Collections;
using System.Drawing.Printing;
using System.Drawing.Imaging;
using System.Drawing.Drawing2D;
using System.Drawing.Text;
using WindowsFormsApplication.mini.Components;
#endregion Used NameSpaces
namespace WindowsFormsApplication.mini
{
    public partial class MembershipManager: Form
    {
        string x;
        #region Constructor
        /// <summary>
        /// Constructor - From Initialization
        /// </summary>
        public MembershipManager()
        {
            InitializeComponent();
        }
        #endregion Constructor

        #region Register Button Click
        /// <summary>
        /// To Insert A New Member into Database
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void btnRegister_Click(object sender, EventArgs e)
        {
            bool result;
            if (txtName.Text != "" && dtpDateTimePicker.Text != "" && cmbOccupation.Text != "" && cmbOccupation.Text != "Select" && txtSalary.Text != "" && cmbMaritalStatus.Text != "" && cmbMaritalStatus.Text != "Select" && cmbHealtStatus.Text != "" && cmbHealtStatus.Text != "Select" && nudNofChildren.Text != "")
            {
                try
                {
                    Member cObj = new Member();
                    cObj.Name = txtName.Text;
                    cObj.DateofBirth = Convert.ToDateTime(dtpDateTimePicker.Text);
                    cObj.Occupation = cmbOccupation.Text;
                    cObj.Martialstatus = cmbMaritalStatus.Text;
                    cObj.Healthstatus = cmbHealtStatus.Text;
                    cObj.Salary = Convert.ToDouble(txtSalary.Text);
                    cObj.ChildrenNumber = Convert.ToInt32(nudNofChildren.Text);

                    result = cObj.InsertAMember();

                    if (result)
                    {
                        MessageBox.Show("One Member added successfully!");
                    }
                    else
                    {
                        MessageBox.Show("Member addition failed!, Please try again");
                    }
                }
                catch (SqlException ex)
                {
                    MessageBox.Show("Error in Addition, Please check again!" + ex.Message);
                }
            }
            else
            {
                MessageBox.Show("Please Provide All Details!");
            }
        }
        #endregion Register Button Click

        #region DatagridviewDatas

        /// <summary>
        /// To View Datas from Database
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void dataGridView1_CellContentClick(object sender, DataGridViewCellEventArgs e)
        {
            if (!dataGridView1.Rows[e.RowIndex].IsNewRow)
            {
                x = dataGridView1.Rows[e.RowIndex].Cells[0].Value.ToString();
                txtNameSearc.Text = dataGridView1.Rows[e.RowIndex].Cells[1].Value.ToString();
                dtpDatpickSearc.Text = dataGridView1.Rows[e.RowIndex].Cells[2].Value.ToString();
                cmbOccupationSearch.Text = dataGridView1.Rows[e.RowIndex].Cells[3].Value.ToString();
                txtSalSearc.Text = dataGridView1.Rows[e.RowIndex].Cells[4].Value.ToString();
                cmbMaritsearch.Text = dataGridView1.Rows[e.RowIndex].Cells[5].Value.ToString();
                cmbHealsearc.Text = dataGridView1.Rows[e.RowIndex].Cells[6].Value.ToString();
                nudnofchildrensearchupdate.Text = dataGridView1.Rows[e.RowIndex].Cells[7].Value.ToString();
            }
        }
        #endregion DatagridviewDatas

        #region Refresh Button Click
        /// <summary>
        /// To Refresh The Page
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void btnRefresh_Click(object sender, EventArgs e)
        {
            try
            {
                Member cObj = new Member();
                DataSet dsMembers = new DataSet();
                dsMembers = cObj.GetAllMembers();
                dataGridView1.DataSource = dsMembers.Tables[0].DefaultView;
            }
            catch (SqlException ex)
            {
                MessageBox.Show("Error in Refreshing, Please check again!" + ex.Message);
            }

        }
        #endregion Refresh Button Click

        #region Update Button Click

        /// <summary>
        /// To Update An Existing Member
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void btnUpdate_Click(object sender, EventArgs e)
        {
            bool result;
            if (txtNameSearc.Text != "" && dtpDatpickSearc.Text != "" && cmbOccupationSearch.Text != "" && txtSalSearc.Text != "" && cmbMaritsearch.Text != "" && cmbHealsearc.Text != "" && nudnofchildrensearchupdate.Text != "")
            {
                try
                {
                    Member upObj = new Member();
                    upObj.MemberId = Convert.ToInt32(x);
                    upObj.Name = txtNameSearc.Text;
                    upObj.DateofBirth = Convert.ToDateTime(dtpDatpickSearc.Text);
                    upObj.Occupation = cmbOccupationSearch.Text;
                    upObj.Martialstatus = cmbMaritsearch.Text;
                    upObj.Healthstatus = cmbHealsearc.Text;
                    upObj.Salary = Convert.ToDouble(txtSalSearc.Text);
                    upObj.ChildrenNumber = Convert.ToInt32(nudnofchildrensearchupdate.Text);
                    result = upObj.UpdateAMember();
                    if (result)
                    {
                        MessageBox.Show("Record Updated Successfully");
                        Member cObj = new Member();
                        DataSet dsMembers = new DataSet();
                        dsMembers = cObj.GetAllMembers();
                        dataGridView1.DataSource = dsMembers.Tables[0].DefaultView;
                    }
                    else
                    {
                        MessageBox.Show("Member Updation failed!, Please try again");
                    }
                }
                catch (SqlException ex)
                {
                    MessageBox.Show("Error in Updating, Please check again!" + ex.Message);
                }
            }
            else
            {
                MessageBox.Show("Please Provide Details!");
            }
        }
        #endregion Update Button Click
        #region Delete Button Click
        /// <summary>
        /// To Delete A Member From Database
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void btnDelete_Click(object sender, EventArgs e)
        {
            bool deleteresult;
            try
            {

                string message = "Do you want to Delete ?";
                string title = "Delete ";
                MessageBoxButtons buttons = MessageBoxButtons.YesNo;
                DialogResult result = MessageBox.Show(message, title, buttons);
                if (result == DialogResult.Yes)
                {
                    int memberIdToDelete;

                    Member deObj = new Member();
                    deObj.MemberId = Convert.ToInt32(x);
                    memberIdToDelete = Convert.ToInt32(x);
                    deleteresult = deObj.DeleteAMember(memberIdToDelete);

                    Member cObj = new Member();
                    DataSet dsMembers = new DataSet();
                    dsMembers = cObj.GetAllMembers();
                    dataGridView1.DataSource = dsMembers.Tables[0].DefaultView;

                    if (deleteresult)
                    {
                        MessageBox.Show("Record deleted Successfully");
                    }
                    else
                    {
                        MessageBox.Show("Member delettion failed!, Please try again");
                    }
                }
            }
            catch (SqlException ex)
            {
                MessageBox.Show("Error in Addition, Please check again!" + ex.Message);
            }
            txtNameSearc.Text = "";
            nudnofchildrensearchupdate.Text = "";
            txtSalSearc.Text = "";
        }
        #endregion Delete Button Click

        #region Search Button Click
        /// <summary>
        /// To Search Members ,By Occupation And Marital Status
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void btnSearch_Click(object sender, EventArgs e)
        {
            string oper;
            Member searchObj = new Member();
            searchObj.Occupation = cmbOccSearch.Text;
            searchObj.Martialstatus = cmbMaritalSearch.Text;
            oper = cmbAnd.Text;
            searchObj.Search(oper);
            DataSet dsMembers = new DataSet();
            dsMembers = searchObj.Search(oper);
            dataGridView1.DataSource = dsMembers.Tables[0];
        }

        #endregion Search Button Click
        #region Salary text box Keypress event
        /// <summary>
        /// Salary Text box Will Acceptt Only Positive numeric Value
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void txtSalary_TextChanged(object sender, EventArgs e)
        {
        }

        private void txtSalary_KeyPress(object sender, KeyPressEventArgs e)
        {
            if (char.IsDigit(e.KeyChar) || char.IsControl(e.KeyChar))
            {
                e.Handled = false;
            }
            else
            {
                e.Handled = true;
            }
        }
        #endregion Salary text box Keypress event

        #region On load Event

        /// <summary>
        /// events happening when form is loaded
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void MembershipManager_Load(object sender, EventArgs e)
        {
            Member cObj = new Member();
            DataSet dsMembers = new DataSet();
            dsMembers = cObj.GetAllMembers();
            dataGridView1.DataSource = dsMembers.Tables[0].DefaultView;
            ArrayList Occupation = new ArrayList();
            Occupation.Add("Select");
            Occupation.Add("Doctor");
            Occupation.Add("Engineer");
            Occupation.Add("Professor");
            foreach(string a in Occupation)
            {
                cmbOccupation.DataSource = Occupation;
            }

            ArrayList Marital = new ArrayList();
            Marital.Add("Select");
            Marital.Add("Married");
            Marital.Add("Single");
            foreach(string a in Marital)
            {
                cmbMaritalStatus.DataSource = Marital;
            }
            ArrayList Health = new ArrayList();
            Health.Add("Select");
            Health.Add("Excellent");
            Health.Add("Good");
            Health.Add("Average");
            Health.Add("Poor");
            foreach(string a in Health)
            {
                cmbHealtStatus.DataSource = Health;
            }
            ArrayList OccSearc = new ArrayList();
            OccSearc.Add("Select");
            OccSearc.Add("Doctor");
            OccSearc.Add("Engineer");
            OccSearc.Add("Professor");
            foreach(string a in OccSearc)
            {
                cmbOccSearch.DataSource = OccSearc;
            }
            ArrayList MaritalSearc = new ArrayList();
            MaritalSearc.Add("Select");
            MaritalSearc.Add("Married");
            MaritalSearc.Add("Single");
            foreach(string a in MaritalSearc)
            {
                cmbMaritalSearch.DataSource = MaritalSearc;
            }
            ArrayList With = new ArrayList();
            With.Add("AND");
            With.Add("OR");
            foreach(string a in With)
            {
                cmbAnd.DataSource = With;
            }#endregion On load Event
        }
    }
}