Members

15         public DeleteMembers()
16         {
17             InitializeComponent();
18         }

20         private void button1_Click(object sender, EventArgs e)
21         {
22             try
23             {
24                 SqlConnection con = new SqlConnection(@"Data Source=.\SQLEXPRESS;AttachDbFilename=F:\Sem.4\C# Projects\GymManagementSystem in C#\GymManagementSystem\Gym.mdf;Integrated Security=True;User Instance=True");
25                 con.Open();
26
27                 string str = "DELETE FROM members WHERE m_id = '" + textBox1.Text + "'";
28
29                 SqlCommand cmd = new SqlCommand(str, con);
30                 cmd.ExecuteNonQuery();
31                 con.Close();
32                 MessageBox.Show(" Members Record Deleted Successfully");
33
34                 using (SqlConnection newcon = new SqlConnection(@"Data Source=.\SQLEXPRESS;AttachDbFilename=F:\Sem.4\C# Projects\GymManagementSystem in C#\GymManagementSystem\Gym.mdf;Integrated Security=True;User Instance=True"))
35                 {
36                     string str1 = "SELECT * from members";
37                     SqlCommand cmd1 = new SqlCommand(str1, newcon);
38                     SqlDataAdapter da = new SqlDataAdapter(cmd1);
39                     DataTable dt = new DataTable();
40                     da.Fill(dt);
41                     dataGridView1.DataSource = new BindingSource(dt, null);
42
43                 }
44             }
45
46             catch (SqlException ex)
47             {
48                 MessageBox.Show(ex.Message);
49                 MessageBox.Show("Please Enter Employee Id..");
50             }
51         }

53         private void DeleteMembers_Load(object sender, EventArgs e)
54         {
55             // TODO: This line of code loads data into the 'gymDataSet1.members' table. You can move, or remove it, as needed.
56             this.membersTableAdapter.Fill(this.gymDataSet1.members);
57             using (SqlConnection newcon = new SqlConnection(@"Data Source=.\SQLEXPRESS;AttachDbFilename=F:\Sem.4\C# Projects\GymManagementSystem in C#\GymManagementSystem\Gym.mdf;Integrated Security=True;User Instance=True"))
58             {
59                 string str1 = "SELECT * from members";
60                 SqlCommand cmd1 = new SqlCommand(str1, newcon);
61                 SqlDataAdapter da = new SqlDataAdapter(cmd1);
62                 DataTable dt = new DataTable();
63                 da.Fill(dt);
64                 dataGridView1.DataSource = new BindingSource(dt, null);
65
66             }
67         }

37         private void searchMemberToolStripMenuItem_Click(object sender, EventArgs e)
38         {
39             SearchMembers obj4 = new SearchMembers();
40             obj4.ShowDialog();
41         }

43         private void updateMemberToolStripMenuItem_Click(object sender, EventArgs e)
44         {
45             DeleteMembers obj5 = new DeleteMembers();
46             obj5.ShowDialog();
47         }

25         private void button1_Click(object sender, EventArgs e)
26         {
27             SqlConnection con = new SqlConnection(@"Data Source=.\SQLEXPRESS;AttachDbFilename=F:\Sem.4\C# Projects\GymManagementSystem in C#\GymManagementSystem\Gym.mdf;Integrated Security=True;User Instance=True");
28             con.Open();
29             string gender = string.Empty;
30             if (radioButton1.Checked)
31             {
32                 gender = "Male";
33             }
34             else if (radioButton2.Checked)
35             {
36                 gender = "Female";
37             }
38             try
39             {
40                 string str = " INSERT INTO members(f_name,l_name,gender,dob,mobile,email,jod,time,address,mem_time) VALUES('" + textBox1.Text + "','" + textBox2.Text + "','" + gender + "','" + textBox3.Text + "','" + textBox4.Text + "','" + textBox5.Text + "','" + textBox6.Text + "','" + comboBox1.Text + "','" + textBox7.Text + "','" + comboBox2.Text + "'); ";
41
42                 SqlCommand cmd = new SqlCommand(str, con);
43                 cmd.ExecuteNonQuery();
44
45                 string str1 = "select max(m_id) from members ;";
46
47                 SqlCommand cmd1 = new SqlCommand(str1, con);
48                 SqlDataReader dr = cmd1.ExecuteReader();
49                 if (dr.Read())
50                 {
51                     MessageBox.Show("" + textBox1.Text + "'s Details is Inserted Successfully.. " + textBox1.Text + "'s Id is " + dr.GetInt32(0) + ".", "Important Message");
52                     this.Hide();
53
54                 }
55                 this.Close();
56             }
57             catch (SqlException excep)
58             {
59                 MessageBox.Show(excep.Message);
60             }
61             con.Close();
62         }

15         public SearchMembers()
16         {
17             InitializeComponent();
18         }

20         private void button1_Click(object sender, EventArgs e)
21         {
22             using (SqlConnection con = new SqlConnection(@"Data Source=.\SQLEXPRESS;AttachDbFilename=F:\Sem.4\C# Projects\GymManagementSystem in C#\GymManagementSystem\Gym.mdf;Integrated Security=True;User Instance=True"))
23             {
24
25                 string str = "SELECT * FROM members WHERE m_id = '" + textBox1.Text + "'";
26                 SqlCommand cmd = new SqlCommand(str, con);
27                 SqlDataAdapter da = new SqlDataAdapter(cmd);
28                 DataTable dt = new DataTable();
29                 da.Fill(dt);
30
31                 dataGridView1.DataSource = new BindingSource(dt, null);
32             }
33
34             textBox1.Text = "";
35         }

37         private void SearchMembers_Load(object sender, EventArgs e)
38         {
39             // TODO: This line of code loads data into the 'gymDataSet.members' table. You can move, or remove it, as needed.
40             this.membersTableAdapter.Fill(this.gymDataSet.members);
41             using (SqlConnection con = new SqlConnection(@"Data Source=.\SQLEXPRESS;AttachDbFilename=F:\Sem.4\C# Projects\GymManagementSystem in C#\GymManagementSystem\Gym.mdf;Integrated Security=True;User Instance=True"))
42             {
43
44                 string str = "SELECT * FROM members";
45                 SqlCommand cmd = new SqlCommand(str, con);
46                 SqlDataAdapter da = new SqlDataAdapter(cmd);
47                 DataTable dt = new DataTable();
48                 da.Fill(dt);
49
50                 dataGridView1.DataSource = new BindingSource(dt, null);
51             }
52         }