Post
Ask Question

ADO.NET CRUD OPERATION 2 Tier

In Program.cs
  1. #region Used NamesSpaces  
  2. using System;  
  3. using System.Collections.Generic;  
  4. using System.Linq;  
  5. using System.Threading.Tasks;  
  6. using System.Windows.Forms;  
  7. using WindowsFormsApplication.mini.Components;#endregion  
  8.   
  9. namespace WindowsFormsApplication.mini   
  10. {  
  11.     public class Program   
  12.     {  
  13.         /// <summary>  
  14.         /// The main entry point for the application.  
  15.         /// </summary>  
  16.         ///   
  17.         [STAThread]  
  18.         static void Main()   
  19.         {  
  20.             Application.EnableVisualStyles();  
  21.             Application.SetCompatibleTextRenderingDefault(false);  
  22.             Application.Run(new MembershipManager());  
  23.         }  
  24.     }  
  25. }  
Then we have to create a folder and i named it as component
Database connection class
  1. #region Used Namespaces  
  2. using System;  
  3. using System.Collections.Generic;  
  4. using System.Linq;  
  5. using System.Text;  
  6. using System.Threading.Tasks;  
  7. using System.Data;  
  8. using System.Data.SqlClient;  
  9. #endregion Used Namespaces  
  10. namespace WindowsFormsApplication.mini.Components   
  11. {  
  12.     class HealthClubDbConnection   
  13.     {  
  14.         #region Public Properties  
  15.         /// <summary>  
  16.         /// Connection string property  
  17.         /// </summary>  
  18.         public static string constring {get;set;}  
  19.         #endregion Public Properties  
  20.         #region Methods  
  21.         #region GetDbConnection  
  22.         /// <summary>  
  23.         /// To establish DataBase Connection...  
  24.         /// </summary>  
  25.         /// <returns>SqlConnection object</returns>  
  26.   
  27.         public static SqlConnection GetDbConnection()   
  28.         {  
  29.             SqlConnection conHealthClub;  
  30.             constring = "Data Source=EL-WS14\\SQLEXPRESS;Initial Catalog=dbs_HealthClubMemberManagement;Integrated Security=True";  
  31.             conHealthClub = new SqlConnection(constring);  
  32.             return conHealthClub;  
  33.         }  
  34.         #endregion GetDbConnection  
  35.         #endregion Methods  
  36.     }  
  37. }  
  38. #endregion Copyright  
Login Class
  1. #region Used Namespaces  
  2. using System;  
  3. using System.Collections.Generic;  
  4. using System.Linq;  
  5. using System.Drawing;  
  6. using System.ComponentModel;  
  7. using System.Windows.Forms;  
  8. using System.Text;  
  9. using System.Threading.Tasks;  
  10. using System.Data;  
  11. using System.Data.SqlClient;  
  12. using WindowsFormsApplication.mini.Components;  
  13. using System.Collections;  
  14. #endregion Used Namespaces  
  15. namespace WindowsFormsApplication.mini.Components   
  16. {  
  17.     class LoginMember   
  18.     {  
  19.         #region Public Properties  
  20.         /// <summary>  
  21.         ///username of logged in user  
  22.         /// </summary>  
  23.         public string Username {get;set;}  
  24.         /// <summary>  
  25.         /// password of logged in user  
  26.         /// </summary>  
  27.         public string Password {get;set;}  
  28.         #endregion Public Properties  
  29.         #region Methods  
  30.         #region ValidateLogin  
  31.         /// <summary>  
  32.         /// Authentication ,If Username and Password Are Correct ;Login   
  33.         /// </summary>  
  34.         ///   
  35.         public bool ValidateLogin()   
  36.         {  
  37.             string loginquery;  
  38.             SqlDataReader dbr;  
  39.   
  40.             SqlConnection conHealthClub = null;  
  41.             bool result = false;  
  42.             SqlCommand cmd;  
  43.   
  44.             try   
  45.             {  
  46.                 int count = 0;  
  47.                 loginquery = "SELECT log_username,log_password from hea_login ";  
  48.                 loginquery += "where log_username=@user and log_password = @pass";  
  49.   
  50.                 conHealthClub = HealthClubDbConnection.GetDbConnection();  
  51.                 conHealthClub.Open();  
  52.   
  53.                 cmd = new SqlCommand(loginquery, conHealthClub);  
  54.   
  55.                 SqlParameter sqlparam1 = cmd.Parameters.AddWithValue("@user", Username);  
  56.                 SqlParameter SqlParam2 = cmd.Parameters.AddWithValue("@Pass", Password);  
  57.                 cmd.ExecuteNonQuery();  
  58.                 dbr = cmd.ExecuteReader();  
  59.   
  60.                 while (dbr.Read())   
  61.                 {  
  62.                     count = count + 1;  
  63.                 }  
  64.   
  65.                 if (count == 1)   
  66.                 {  
  67.                     result = true;  
  68.                 }   
  69.                 else  
  70.                 {  
  71.                     result = false;  
  72.                 }  
  73.   
  74.             }   
  75.             catch (Exception es)  
  76.             {  
  77.                 MessageBox.Show(es.Message);  
  78.             }   
  79.             finally  
  80.             {  
  81.                 conHealthClub.Close();  
  82.             }  
  83.             return result;  
  84.         }#endregion ValidateLogin  
  85.         #endregion Methods  
  86.     }  
  87. }  
Management Class
  1. #region Used Namespaces  
  2. using System;  
  3. using System.Collections.Generic;  
  4. using System.Linq;  
  5. using System.Text;  
  6. using System.Threading.Tasks;  
  7. using System.Data;  
  8. using System.Data.SqlClient;  
  9. using System.Windows.Forms;  
  10. using WindowsFormsApplication.mini.Components;  
  11. #endregion Used Namespaces  
  12. namespace WindowsFormsApplication.mini.Components   
  13. {  
  14.     class Member   
  15.     {  
  16.         #region Properties  
  17.         /// <summary>  
  18.         /// memberid of new member  
  19.         /// </summary>  
  20.         public int MemberId {get;set;}  
  21.         /// <summary>  
  22.         /// name if new member  
  23.         /// </summary>  
  24.         public string Name {get;set;}  
  25.         /// <summary>  
  26.         /// date of birth of new member  
  27.         /// </summary>  
  28.         public DateTime DateofBirth {get;set;}  
  29.         /// <summary>  
  30.         /// occupation of new member  
  31.         /// </summary>  
  32.         public string Occupation {get;set;}  
  33.         /// <summary>  
  34.         /// salary of new member  
  35.         /// </summary>  
  36.         public double Salary {get;set;}  
  37.         /// <summary>  
  38.         /// marital status of new member  
  39.         /// </summary>  
  40.         public string Martialstatus {get;set;}  
  41.         /// <summary>  
  42.         /// health status of new member  
  43.         /// </summary>  
  44.         public string Healthstatus {get;set;}  
  45.         /// <summary>  
  46.         /// no of children of new member  
  47.         /// </summary>  
  48.         public int ChildrenNumber {get;set;}  
  49.         #endregion Properties  
  50.         #region Methods  
  51.         #region GetAllMembers  
  52.         /// <summary>  
  53.         /// To Get All Members From Member table in the database  
  54.         /// </summary>  
  55.         /// <returns>dataset of members</returns>  
  56.         public DataSet GetAllMembers()   
  57.         {  
  58.             SqlDataAdapter daMembers;  
  59.   
  60.             SqlConnection conObj = null;  
  61.             DataSet dsMembers = null;  
  62.   
  63.             try   
  64.             {  
  65.                 string selectQuery = "SELECT mem_memberid,mem_name,mem_dateofbirth,mem_occupation,mem_salary,";  
  66.                 selectQuery += "mem_martialstatus,mem_healthstatus,mem_noofchildren FROM hea_member";  
  67.   
  68.                 conObj = HealthClubDbConnection.GetDbConnection();  
  69.                 conObj.Open();  
  70.   
  71.                 daMembers = new SqlDataAdapter(selectQuery, conObj);  
  72.                 dsMembers = new DataSet();  
  73.                 daMembers.Fill(dsMembers);  
  74.             }  
  75.             catch (Exception es)   
  76.             {  
  77.                 throw es;  
  78.             }  
  79.             finally  
  80.             {  
  81.                 conObj.Close();  
  82.             }  
  83.   
  84.             return dsMembers;   
  85.         }#endregion GetAllMembers  
  86.         #region CheckExistingMember  
  87.         /// <summary>  
  88.         /// Method to check whether the Member is existing  
  89.         /// </summary>  
  90.         /// <returns>true/false</returns>  
  91.         public bool CheckExistingMember()   
  92.         {  
  93.             string selectQuery;  
  94.             SqlCommand cmdSelect;  
  95.             SqlDataReader drSelect;  
  96.             SqlConnection cObj = null;  
  97.             int count = 0;  
  98.             bool result = false;  
  99.             try   
  100.             {  
  101.                 selectQuery = "SELECT mem_name,mem_dateofbirth from hea_member where mem_name=@namepass and mem_dateofbirth = @Datepass";  
  102.   
  103.                 cObj = HealthClubDbConnection.GetDbConnection();  
  104.                 cObj.Open();  
  105.   
  106.                 cmdSelect = new SqlCommand(selectQuery, cObj);  
  107.                 SqlParameter sqlparam8 = cmdSelect.Parameters.AddWithValue("@namepass", Name);  
  108.                 SqlParameter SqlParam9 = cmdSelect.Parameters.AddWithValue("@Datepass", DateofBirth);  
  109.                 drSelect = cmdSelect.ExecuteReader();  
  110.   
  111.                 while (drSelect.Read())   
  112.                 {  
  113.                     count = count + 1;  
  114.                 }  
  115.   
  116.                 if (count > 0)   
  117.                 {  
  118.                     result = true;  
  119.                 }   
  120.                 else   
  121.                 {  
  122.                     result = false;  
  123.                 }  
  124.             }   
  125.             catch (SqlException ex)   
  126.             {  
  127.                 throw ex;  
  128.             } finally   
  129.             {  
  130.                 cObj.Close();  
  131.             }  
  132.             return result;  
  133.         }  
  134.         #endregion CheckExistingMember  
  135.         #region InsertAMember  
  136.         /// <summary>  
  137.         /// To Insert A Member Into Database  
  138.         /// </summary>  
  139.         /// <returns>true/false</returns>  
  140.         public bool InsertAMember()   
  141.         {  
  142.             string insertQuery;  
  143.             SqlCommand cmdInsert;  
  144.             int rowsAffected;  
  145.             SqlConnection cObj = null;  
  146.             bool result = false;  
  147.             bool isexists = false;  
  148.   
  149.             try   
  150.             {  
  151.                 isexists = CheckExistingMember();  
  152.                 if (!isexists)   
  153.                 {  
  154.                     insertQuery = "insert into hea_member values(@Name,@DOB,@Occupation,@Salary,";  
  155.                     insertQuery += "@MartialStatus,@HealthStatus,@NoOfChildren )";  
  156.   
  157.                     cObj = HealthClubDbConnection.GetDbConnection();  
  158.                     cObj.Open();  
  159.   
  160.                     cmdInsert = new SqlCommand(insertQuery, cObj);  
  161.                     cmdInsert.Connection = cObj;  
  162.   
  163.                     SqlParameter SqlParam1 = cmdInsert.Parameters.AddWithValue("@Name", Name);  
  164.                     SqlParameter SqlParam2 = cmdInsert.Parameters.AddWithValue("@DOB", DateofBirth);  
  165.                     SqlParameter SqlParam3 = cmdInsert.Parameters.AddWithValue("@Occupation", Occupation);  
  166.                     SqlParameter SqlParam4 = cmdInsert.Parameters.AddWithValue("@Salary", Salary);  
  167.                     SqlParameter SqlParam5 = cmdInsert.Parameters.AddWithValue("@MartialStatus", Martialstatus);  
  168.                     SqlParameter SqlParam6 = cmdInsert.Parameters.AddWithValue("@HealthStatus", Healthstatus);  
  169.                     SqlParameter SqlParam7 = cmdInsert.Parameters.AddWithValue("@NoOfChildren", ChildrenNumber);  
  170.                     rowsAffected = cmdInsert.ExecuteNonQuery();  
  171.   
  172.                     if (rowsAffected > 0)  
  173.                     {  
  174.                         result = true;  
  175.                     }   
  176.                     else   
  177.                     {  
  178.                         result = false;  
  179.                     }  
  180.                 }   
  181.                 else   
  182.                 {  
  183.                     result = false;  
  184.                 }  
  185.             }   
  186.             catch (Exception es)   
  187.             {  
  188.                 throw es;  
  189.             }   
  190.             finally   
  191.             {  
  192.                 cObj.Close();  
  193.             }  
  194.             return result;  
  195.         }  
  196.         #endregion InsertMembers  
  197.         #region UpdateAMember  
  198.         /// <summary>  
  199.         /// To Update An Existing Member   
  200.         /// </summary>  
  201.         public bool UpdateAMember()   
  202.         {  
  203.             string updateQuery;  
  204.             int rowsAffected;  
  205.             SqlCommand cmdUpdate;  
  206.   
  207.             SqlConnection conobj = null;  
  208.             bool result = false;  
  209.   
  210.             try  
  211.             {  
  212.                 updateQuery = "update hea_member set mem_name=@name,mem_dateofbirth=@DOB,mem_occupation=@Occupation,";  
  213.                 updateQuery += "mem_salary=@Salary,mem_martialstatus=@MartialStatus,mem_healthstatus=@HealthStatus,";  
  214.                 updateQuery += "mem_noofchildren=@NoOfChildren where mem_memberid=@id";  
  215.   
  216.                 conobj = HealthClubDbConnection.GetDbConnection();  
  217.                 conobj.Open();  
  218.   
  219.                 cmdUpdate = new SqlCommand(updateQuery, conobj);  
  220.                 cmdUpdate.Connection = conobj;  
  221.   
  222.                 SqlParameter sqlparam1 = cmdUpdate.Parameters.AddWithValue("@id", MemberId);  
  223.                 SqlParameter SqlParam2 = cmdUpdate.Parameters.AddWithValue("@Name", Name);  
  224.                 SqlParameter SqlParam3 = cmdUpdate.Parameters.AddWithValue("@DOB", DateofBirth);  
  225.                 SqlParameter SqlParam4 = cmdUpdate.Parameters.AddWithValue("@Occupation", Occupation);  
  226.                 SqlParameter SqlParam5 = cmdUpdate.Parameters.AddWithValue("@Salary", Salary);  
  227.                 SqlParameter SqlParam6 = cmdUpdate.Parameters.AddWithValue("@MartialStatus", Martialstatus);  
  228.                 SqlParameter SqlParam7 = cmdUpdate.Parameters.AddWithValue("@HealthStatus", Healthstatus);  
  229.                 SqlParameter SqlParam8 = cmdUpdate.Parameters.AddWithValue("@NoOfChildren", ChildrenNumber);  
  230.                 rowsAffected = cmdUpdate.ExecuteNonQuery();  
  231.   
  232.                 if (rowsAffected > 0)   
  233.                 {  
  234.                     result = true;  
  235.                 }   
  236.                 else  
  237.                 {  
  238.                     result = false;  
  239.                 }  
  240.             }   
  241.             catch (Exception es)  
  242.             {  
  243.                 throw es;  
  244.             }   
  245.             finally   
  246.             {  
  247.                 conobj.Close();  
  248.             }  
  249.             return result;  
  250.         }  
  251.         #endregion UpdateAMember  
  252.         #region DeleteAMember  
  253.         /// <summary>  
  254.         /// To Delete A Member From Database  
  255.         /// </summary>  
  256.         /// <param name="memberIdToDelete">the member id selected to delete(int)</param>  
  257.         /// <returns>true/false</returns>  
  258.         public bool DeleteAMember(int memberIdToDelete)   
  259.         {  
  260.             string deleteQuery;  
  261.             SqlCommand cmdDelete;  
  262.             int rowsAffected;  
  263.   
  264.             SqlConnection conobj = null;  
  265.             bool result = false;  
  266.   
  267.             try   
  268.             {  
  269.                 deleteQuery = "delete hea_member where mem_memberid=@id";  
  270.   
  271.                 conobj = HealthClubDbConnection.GetDbConnection();  
  272.                 cmdDelete = new SqlCommand(deleteQuery, conobj);  
  273.                 conobj.Open();  
  274.                 cmdDelete.Connection = conobj;  
  275.   
  276.                 SqlParameter sqlparam1 = cmdDelete.Parameters.AddWithValue("@id", memberIdToDelete);  
  277.                 rowsAffected = cmdDelete.ExecuteNonQuery();  
  278.   
  279.                 if (rowsAffected > 0)   
  280.                 {  
  281.                     result = true;  
  282.                 }   
  283.                 else  
  284.                 {  
  285.                     result = false;  
  286.                 }  
  287.   
  288.             }   
  289.             catch (Exception es)   
  290.             {  
  291.                 throw es;  
  292.             }  
  293.             finally   
  294.             {  
  295.                 conobj.Close();  
  296.             }  
  297.             return result;  
  298.         }  
  299.         #endregion DeleteMember  
  300.         #region Search Member  
  301.         /// <summary>  
  302.         /// To Search Members ,By Occupation And Marital Status   
  303.         /// </summary>  
  304.         /// <param name="oper">the operator to be used in the search query (and/or)</param>  
  305.         /// <returns>Dataset of members matching the search query</returns>  
  306.         public DataSet Search(string oper)   
  307.         {  
  308.             SqlCommand cmdSearch;  
  309.             SqlDataAdapter daSearch;  
  310.             string searchQuery;  
  311.   
  312.             SqlConnection conobj = null;  
  313.             DataSet ds = null;  
  314.   
  315.             try   
  316.             {  
  317.                 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 ";  
  318.   
  319.                 conobj = HealthClubDbConnection.GetDbConnection();  
  320.                 conobj.Open();  
  321.                 cmdSearch = new SqlCommand(searchQuery, conobj);  
  322.   
  323.                 SqlParameter SqlParam1 = cmdSearch.Parameters.AddWithValue("@Occupation", Occupation);  
  324.                 SqlParameter SqlParam2 = cmdSearch.Parameters.AddWithValue("@MartialStatus", Martialstatus);  
  325.                 daSearch = new SqlDataAdapter(cmdSearch);  
  326.                 ds = new DataSet();  
  327.                 daSearch.Fill(ds);  
  328.             }   
  329.             catch (Exception es)   
  330.             {  
  331.                 throw es;  
  332.             }  
  333.             finally   
  334.             {  
  335.                 conobj.Close();  
  336.             }  
  337.             return ds;  
  338.         }  
  339.     }  
  340.     #endregion Search Member  
  341.     #endregion Methods  
  342. }  
LoginForm
  1. #region Used Namespaces  
  2. using System;  
  3. using System.Collections.Generic;  
  4. using System.ComponentModel;  
  5. using System.Data;  
  6. using System.Drawing;  
  7. using System.Linq;  
  8. using System.Text;  
  9. using System.Threading.Tasks;  
  10. using System.Windows.Forms;  
  11. using System.Data.SqlClient;  
  12. using System.Configuration;  
  13. using.WindowsFormsApplication.mini.Components;  
  14. #endregion Used Namespace  
  15. namespace.WindowsFormsApplication.mini   
  16. {  
  17.     public partial class SocialLogin: Form   
  18.     {  
  19.         public SocialLogin()   
  20.         {  
  21.             InitializeComponent();  
  22.         }  
  23.         private void HealthClubMemberManagement_Load(object sender, EventArgs e)   
  24.         {  
  25.         }  
  26.         private void lblUsername_Click(object sender, EventArgs e)   
  27.         {  
  28.         }  
  29.         #region Login Button Click Event  
  30.         /// <summary>  
  31.         /// Enable Login If UserName And PassWord Are Correct  
  32.         /// </summary>  
  33.         /// <param name="sender"></param>  
  34.         /// <param name="e"></param>  
  35.         private void btnLogin_Click(object sender, EventArgs e)   
  36.         {  
  37.             bool result;  
  38.             if (!(txtUsername.Text == string.Empty))  
  39.             {  
  40.                 if (!(txtPassword.Text == string.Empty))   
  41.                 {  
  42.                     LoginMember logobj = new LoginMember();  
  43.                     logobj.Username = txtUsername.Text;  
  44.                     logobj.Password = txtPassword.Text;  
  45.   
  46.                     result = logobj.ValidateLogin();  
  47.   
  48.                     if (result == true)  
  49.                     {  
  50.                         MembershipManager newregobj = new MembershipManager();  
  51.                         newregobj.Show();  
  52.                     }  
  53.                     else   
  54.                     {  
  55.                         MessageBox.Show(" username and password incorrect");  
  56.                     }  
  57.                 }  
  58.                 else   
  59.                 {  
  60.                     MessageBox.Show("Please Enter Password");  
  61.                 }  
  62.             }   
  63.             else  
  64.             {  
  65.                 MessageBox.Show("Please Enter Username");  
  66.             }  
  67.         }  
  68.         #endregion Login Button Click Event  
  69.         #region onload  
  70.         private void frmSocialLogin_Load(object sender, EventArgs e) {  
  71.         }  
  72.         #endregion onload  
  73.     }  
  74. }  
MemberManagementForm
  1. #region Used NameSpaces  
  2. using System;  
  3. using System.Collections.Generic;  
  4. using System.ComponentModel;  
  5. using System.Data;  
  6. using System.Drawing;  
  7. using System.Linq;  
  8. using System.Text;  
  9. using System.Threading.Tasks;  
  10. using System.Windows.Forms;  
  11. using System.Data.SqlClient;  
  12. using System.Configuration;  
  13. using System.Collections;  
  14. using System.Drawing.Printing;  
  15. using System.Drawing.Imaging;  
  16. using System.Drawing.Drawing2D;  
  17. using System.Drawing.Text;  
  18. using WindowsFormsApplication.mini.Components;  
  19. #endregion Used NameSpaces  
  20. namespace WindowsFormsApplication.mini   
  21. {  
  22.     public partial class MembershipManager: Form   
  23.     {  
  24.         string x;  
  25.         #region Constructor  
  26.         /// <summary>  
  27.         /// Constructor - From Initialization  
  28.         /// </summary>  
  29.         public MembershipManager()   
  30.         {  
  31.             InitializeComponent();  
  32.         }  
  33.         #endregion Constructor  
  34.  
  35.         #region Register Button Click  
  36.         /// <summary>  
  37.         /// To Insert A New Member into Database   
  38.         /// </summary>  
  39.         /// <param name="sender"></param>  
  40.         /// <param name="e"></param>  
  41.         private void btnRegister_Click(object sender, EventArgs e)   
  42.         {  
  43.             bool result;  
  44.             if (txtName.Text != "" && dtpDateTimePicker.Text != "" && cmbOccupation.Text != "" && cmbOccupation.Text != "Select" && txtSalary.Text != "" && cmbMaritalStatus.Text != "" && cmbMaritalStatus.Text != "Select" && cmbHealtStatus.Text != "" && cmbHealtStatus.Text != "Select" && nudNofChildren.Text != "")   
  45.             {  
  46.                 try   
  47.                 {  
  48.                     Member cObj = new Member();  
  49.                     cObj.Name = txtName.Text;  
  50.                     cObj.DateofBirth = Convert.ToDateTime(dtpDateTimePicker.Text);  
  51.                     cObj.Occupation = cmbOccupation.Text;  
  52.                     cObj.Martialstatus = cmbMaritalStatus.Text;  
  53.                     cObj.Healthstatus = cmbHealtStatus.Text;  
  54.                     cObj.Salary = Convert.ToDouble(txtSalary.Text);  
  55.                     cObj.ChildrenNumber = Convert.ToInt32(nudNofChildren.Text);  
  56.   
  57.                     result = cObj.InsertAMember();  
  58.   
  59.                     if (result)   
  60.                     {  
  61.                         MessageBox.Show("One Member added successfully!");  
  62.                     }   
  63.                     else  
  64.                     {  
  65.                         MessageBox.Show("Member addition failed!, Please try again");  
  66.                     }  
  67.                 }  
  68.                 catch (SqlException ex)  
  69.                 {  
  70.                     MessageBox.Show("Error in Addition, Please check again!" + ex.Message);  
  71.                 }  
  72.             }   
  73.             else   
  74.             {  
  75.                 MessageBox.Show("Please Provide All Details!");  
  76.             }  
  77.         }  
  78.         #endregion Register Button Click  
  79.  
  80.         #region DatagridviewDatas  
  81.   
  82.         /// <summary>  
  83.         /// To View Datas from Database   
  84.         /// </summary>  
  85.         /// <param name="sender"></param>  
  86.         /// <param name="e"></param>  
  87.         private void dataGridView1_CellContentClick(object sender, DataGridViewCellEventArgs e)   
  88.         {  
  89.             if (!dataGridView1.Rows[e.RowIndex].IsNewRow)   
  90.             {  
  91.                 x = dataGridView1.Rows[e.RowIndex].Cells[0].Value.ToString();  
  92.                 txtNameSearc.Text = dataGridView1.Rows[e.RowIndex].Cells[1].Value.ToString();  
  93.                 dtpDatpickSearc.Text = dataGridView1.Rows[e.RowIndex].Cells[2].Value.ToString();  
  94.                 cmbOccupationSearch.Text = dataGridView1.Rows[e.RowIndex].Cells[3].Value.ToString();  
  95.                 txtSalSearc.Text = dataGridView1.Rows[e.RowIndex].Cells[4].Value.ToString();  
  96.                 cmbMaritsearch.Text = dataGridView1.Rows[e.RowIndex].Cells[5].Value.ToString();  
  97.                 cmbHealsearc.Text = dataGridView1.Rows[e.RowIndex].Cells[6].Value.ToString();  
  98.                 nudnofchildrensearchupdate.Text = dataGridView1.Rows[e.RowIndex].Cells[7].Value.ToString();  
  99.             }  
  100.         }  
  101.         #endregion DatagridviewDatas  
  102.  
  103.         #region Refresh Button Click  
  104.         /// <summary>  
  105.         /// To Refresh The Page  
  106.         /// </summary>  
  107.         /// <param name="sender"></param>  
  108.         /// <param name="e"></param>  
  109.         private void btnRefresh_Click(object sender, EventArgs e)   
  110.         {  
  111.             try   
  112.             {  
  113.                 Member cObj = new Member();  
  114.                 DataSet dsMembers = new DataSet();  
  115.                 dsMembers = cObj.GetAllMembers();  
  116.                 dataGridView1.DataSource = dsMembers.Tables[0].DefaultView;  
  117.             }   
  118.             catch (SqlException ex)  
  119.             {  
  120.                 MessageBox.Show("Error in Refreshing, Please check again!" + ex.Message);  
  121.             }  
  122.   
  123.         }  
  124.         #endregion Refresh Button Click  
  125.  
  126.         #region Update Button Click  
  127.   
  128.         /// <summary>  
  129.         /// To Update An Existing Member   
  130.         /// </summary>  
  131.         /// <param name="sender"></param>  
  132.         /// <param name="e"></param>  
  133.         private void btnUpdate_Click(object sender, EventArgs e)   
  134.         {  
  135.             bool result;  
  136.             if (txtNameSearc.Text != "" && dtpDatpickSearc.Text != "" && cmbOccupationSearch.Text != "" && txtSalSearc.Text != "" && cmbMaritsearch.Text != "" && cmbHealsearc.Text != "" && nudnofchildrensearchupdate.Text != "")   
  137.             {  
  138.                 try  
  139.                 {  
  140.                     Member upObj = new Member();  
  141.                     upObj.MemberId = Convert.ToInt32(x);  
  142.                     upObj.Name = txtNameSearc.Text;  
  143.                     upObj.DateofBirth = Convert.ToDateTime(dtpDatpickSearc.Text);  
  144.                     upObj.Occupation = cmbOccupationSearch.Text;  
  145.                     upObj.Martialstatus = cmbMaritsearch.Text;  
  146.                     upObj.Healthstatus = cmbHealsearc.Text;  
  147.                     upObj.Salary = Convert.ToDouble(txtSalSearc.Text);  
  148.                     upObj.ChildrenNumber = Convert.ToInt32(nudnofchildrensearchupdate.Text);  
  149.                     result = upObj.UpdateAMember();  
  150.                     if (result)  
  151.                     {  
  152.                         MessageBox.Show("Record Updated Successfully");  
  153.                         Member cObj = new Member();  
  154.                         DataSet dsMembers = new DataSet();  
  155.                         dsMembers = cObj.GetAllMembers();  
  156.                         dataGridView1.DataSource = dsMembers.Tables[0].DefaultView;  
  157.                     }  
  158.                     else  
  159.                     {  
  160.                         MessageBox.Show("Member Updation failed!, Please try again");  
  161.                     }  
  162.                 }  
  163.                 catch (SqlException ex)   
  164.                 {  
  165.                     MessageBox.Show("Error in Updating, Please check again!" + ex.Message);  
  166.                 }  
  167.             }  
  168.             else   
  169.             {  
  170.                 MessageBox.Show("Please Provide Details!");  
  171.             }  
  172.         }  
  173.         #endregion Update Button Click  
  174.         #region Delete Button Click  
  175.         /// <summary>  
  176.         /// To Delete A Member From Database  
  177.         /// </summary>  
  178.         /// <param name="sender"></param>  
  179.         /// <param name="e"></param>  
  180.         private void btnDelete_Click(object sender, EventArgs e)   
  181.         {  
  182.             bool deleteresult;  
  183.             try  
  184.             {  
  185.   
  186.                 string message = "Do you want to Delete ?";  
  187.                 string title = "Delete ";  
  188.                 MessageBoxButtons buttons = MessageBoxButtons.YesNo;  
  189.                 DialogResult result = MessageBox.Show(message, title, buttons);  
  190.                 if (result == DialogResult.Yes)   
  191.                 {  
  192.                     int memberIdToDelete;  
  193.   
  194.                     Member deObj = new Member();  
  195.                     deObj.MemberId = Convert.ToInt32(x);  
  196.                     memberIdToDelete = Convert.ToInt32(x);  
  197.                     deleteresult = deObj.DeleteAMember(memberIdToDelete);  
  198.   
  199.                     Member cObj = new Member();  
  200.                     DataSet dsMembers = new DataSet();  
  201.                     dsMembers = cObj.GetAllMembers();  
  202.                     dataGridView1.DataSource = dsMembers.Tables[0].DefaultView;  
  203.   
  204.                     if (deleteresult)  
  205.                     {  
  206.                         MessageBox.Show("Record deleted Successfully");  
  207.                     }   
  208.                     else   
  209.                     {  
  210.                         MessageBox.Show("Member delettion failed!, Please try again");  
  211.                     }  
  212.                 }  
  213.             }   
  214.             catch (SqlException ex)   
  215.             {  
  216.                 MessageBox.Show("Error in Addition, Please check again!" + ex.Message);  
  217.             }  
  218.             txtNameSearc.Text = "";  
  219.             nudnofchildrensearchupdate.Text = "";  
  220.             txtSalSearc.Text = "";  
  221.         }  
  222.         #endregion Delete Button Click  
  223.  
  224.         #region Search Button Click  
  225.         /// <summary>  
  226.         /// To Search Members ,By Occupation And Marital Status   
  227.         /// </summary>  
  228.         /// <param name="sender"></param>  
  229.         /// <param name="e"></param>  
  230.         private void btnSearch_Click(object sender, EventArgs e)   
  231.         {  
  232.             string oper;  
  233.             Member searchObj = new Member();  
  234.             searchObj.Occupation = cmbOccSearch.Text;  
  235.             searchObj.Martialstatus = cmbMaritalSearch.Text;  
  236.             oper = cmbAnd.Text;  
  237.             searchObj.Search(oper);  
  238.             DataSet dsMembers = new DataSet();  
  239.             dsMembers = searchObj.Search(oper);  
  240.             dataGridView1.DataSource = dsMembers.Tables[0];  
  241.         }  
  242.  
  243.         #endregion Search Button Click  
  244.         #region Salary text box Keypress event  
  245.         /// <summary>  
  246.         /// Salary Text box Will Acceptt Only Positive numeric Value  
  247.         /// </summary>  
  248.         /// <param name="sender"></param>  
  249.         /// <param name="e"></param>  
  250.         private void txtSalary_TextChanged(object sender, EventArgs e)   
  251.         {  
  252.         }  
  253.   
  254.         private void txtSalary_KeyPress(object sender, KeyPressEventArgs e)   
  255.         {  
  256.             if (char.IsDigit(e.KeyChar) || char.IsControl(e.KeyChar))  
  257.             {  
  258.                 e.Handled = false;  
  259.             }  
  260.             else   
  261.             {  
  262.                 e.Handled = true;  
  263.             }  
  264.         }  
  265.         #endregion Salary text box Keypress event  
  266.  
  267.         #region On load Event  
  268.   
  269.         /// <summary>  
  270.         /// events happening when form is loaded  
  271.         /// </summary>  
  272.         /// <param name="sender"></param>  
  273.         /// <param name="e"></param>  
  274.         private void MembershipManager_Load(object sender, EventArgs e)   
  275.         {  
  276.             Member cObj = new Member();  
  277.             DataSet dsMembers = new DataSet();  
  278.             dsMembers = cObj.GetAllMembers();  
  279.             dataGridView1.DataSource = dsMembers.Tables[0].DefaultView;  
  280.             ArrayList Occupation = new ArrayList();  
  281.             Occupation.Add("Select");  
  282.             Occupation.Add("Doctor");  
  283.             Occupation.Add("Engineer");  
  284.             Occupation.Add("Professor");  
  285.             foreach(string a in Occupation)  
  286.             {  
  287.                 cmbOccupation.DataSource = Occupation;  
  288.             }  
  289.   
  290.             ArrayList Marital = new ArrayList();  
  291.             Marital.Add("Select");  
  292.             Marital.Add("Married");  
  293.             Marital.Add("Single");  
  294.             foreach(string a in Marital)   
  295.             {  
  296.                 cmbMaritalStatus.DataSource = Marital;  
  297.             }  
  298.             ArrayList Health = new ArrayList();  
  299.             Health.Add("Select");  
  300.             Health.Add("Excellent");  
  301.             Health.Add("Good");  
  302.             Health.Add("Average");  
  303.             Health.Add("Poor");  
  304.             foreach(string a in Health)  
  305.             {  
  306.                 cmbHealtStatus.DataSource = Health;  
  307.             }  
  308.             ArrayList OccSearc = new ArrayList();  
  309.             OccSearc.Add("Select");  
  310.             OccSearc.Add("Doctor");  
  311.             OccSearc.Add("Engineer");  
  312.             OccSearc.Add("Professor");  
  313.             foreach(string a in OccSearc)  
  314.             {  
  315.                 cmbOccSearch.DataSource = OccSearc;  
  316.             }  
  317.             ArrayList MaritalSearc = new ArrayList();  
  318.             MaritalSearc.Add("Select");  
  319.             MaritalSearc.Add("Married");  
  320.             MaritalSearc.Add("Single");  
  321.             foreach(string a in MaritalSearc)   
  322.             {  
  323.                 cmbMaritalSearch.DataSource = MaritalSearc;  
  324.             }  
  325.             ArrayList With = new ArrayList();  
  326.             With.Add("AND");  
  327.             With.Add("OR");  
  328.             foreach(string a in With)   
  329.             {  
  330.                 cmbAnd.DataSource = With;  
  331.             }#endregion On load Event  
  332.         }  
  333.     }  
  334. }