Hệ thống quản lý phòng tập trong C#
1 using System;
2 using System.Collections.Generic;
3 using System.ComponentModel;
4 using System.Data;
5 using System.Drawing;
6 using System.Linq;
7 using System.Text;
8 using System.Windows.Forms;
9 using System.Data.SqlClient;
10
11 namespace GymManagementSystem
12 {
13 public partial class DeleteMembers : Form
14 {
15 public DeleteMembers()
16 {
17 InitializeComponent();
18 }
19
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 }
52
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 }
68 }
69 }
TODO: This line of code loads data into the 'gymDataSet1.members' table. You can move, or remove it, as needed.