-
Notifications
You must be signed in to change notification settings - Fork 0
/
Form1.cs
90 lines (74 loc) · 3.01 KB
/
Form1.cs
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
using System.Data.SqlClient;
namespace WinFormsApp1
{
public partial class Form1 : Form
{
public Form1()
{
InitializeComponent();
}
private void button1_Click(object sender, EventArgs e)
{
//creating sql connection
int ID=int.Parse(txtID.Text);
SqlConnection con = new SqlConnection(@"Data Source=(LocalDB)\MSSQLLocalDB;AttachDbFilename=""C:\Users\USER\Dropbox\PC (2)\Documents\lastDB.mdf"";Integrated Security=True;Connect Timeout=30");
//creating sql query
string qry = "insert into InFoTable values ('" + ID + "') ";
//create the command
SqlCommand cmd = new SqlCommand(qry, con);
//handling exceptions
try
{
con.Open(); //opening conncetion
cmd.ExecuteNonQuery(); //executing query
MessageBox.Show("Data Inserted Successfully");
}
catch(Exception ex)
{
MessageBox.Show(ex.Message.ToString());
}
}
private void button2_Click(object sender, EventArgs e)
{
//creating sql connection
int ID = int.Parse(txtID.Text);
SqlConnection con = new SqlConnection(@"Data Source=(LocalDB)\MSSQLLocalDB;AttachDbFilename=""C:\Users\USER\Dropbox\PC (2)\Documents\lastDB.mdf"";Integrated Security=True;Connect Timeout=30");
//creating sql query
string qry = "delete from InFoTable where ID = '"+ID+"' ";
//create the command
SqlCommand cmd = new SqlCommand(qry, con);
//handling exceptions
try
{
con.Open(); //opening conncetion
cmd.ExecuteNonQuery(); //executing query
MessageBox.Show("Data Deleted Successfully");
}
catch (Exception ex)
{
MessageBox.Show(ex.Message.ToString());
}
}
private void button3_Click(object sender, EventArgs e)
{
//creating sql connection
int ID = int.Parse(txtID.Text);
SqlConnection con = new SqlConnection(@"Data Source=(LocalDB)\MSSQLLocalDB;AttachDbFilename=""C:\Users\USER\Dropbox\PC (2)\Documents\lastDB.mdf"";Integrated Security=True;Connect Timeout=30");
//creating sql query
string qry = "update SET InFoTable where ID = '" + ID + "' ";
//create the command
SqlCommand cmd = new SqlCommand(qry, con);
//handling exceptions
try
{
con.Open(); //opening conncetion
cmd.ExecuteNonQuery(); //executing query
MessageBox.Show("Data Updated Successfully");
}
catch (Exception ex)
{
MessageBox.Show(ex.Message.ToString());
}
}
}
}