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 NewMember : Form
14 {
15 public NewMember()
16 {
17 InitializeComponent();
18 }
19
20 private void label6_Click(object sender, EventArgs e)
21 {
22
23 }
24
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 }
63 }
64 }