Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- using System.Drawing;
- using System.Linq;
- using System.Text;
- using System.Windows.Forms;
- using System.Data.SqlClient;
- namespace ChainOfStores
- {
- public partial class Form1 : Form
- {
- public Form1()
- {
- InitializeComponent();
- }
- private void Insert_Click(object sender, EventArgs e)
- {
- SqlConnection con = new SqlConnection("Data Source=(LocalDB)\\MSSQLLocalDB;AttachDbFilename=C:\\Users\\mihai\\source\\repos\\ChainOfStores\\ChainOfStores\\Database1.mdf;Integrated Security=True");
- con.Open();
- SqlCommand cmd = new SqlCommand("INSERT INTO Store VALUES (@Company,@FullName,@Address,@Manufacturer,@Invested,@Shareholding,@Number,@Registration)", con);
- cmd.Parameters.AddWithValue("@Company", Company.Text);
- cmd.Parameters.AddWithValue("@FullName", fullName.Text);
- cmd.Parameters.AddWithValue("@Address", Address.Text);
- cmd.Parameters.AddWithValue("@Manufacturer", Manufacturer.Text);
- cmd.Parameters.AddWithValue("@Invested", Invested.Text);
- cmd.Parameters.AddWithValue("@Shareholding", Shareholding.Text);
- cmd.Parameters.AddWithValue("@Number", Number.Text);
- cmd.Parameters.AddWithValue("@Registration", Registration.Text);
- cmd.ExecuteNonQuery();
- con.Close();
- MessageBox.Show("Added Successfully!","",MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
- }
- private void Edit_Click(object sender, EventArgs e)
- {
- SqlConnection con = new SqlConnection("Data Source=(LocalDB)\\MSSQLLocalDB;AttachDbFilename=C:\\Users\\mihai\\source\\repos\\ChainOfStores\\ChainOfStores\\Database1.mdf;Integrated Security=True");
- con.Open();
- SqlCommand cmd = new SqlCommand("Update Store set Company=@Company",con);
- cmd.Parameters.AddWithValue("@Company", Company.Text);
- cmd.ExecuteNonQuery();
- con.Close();
- MessageBox.Show("Edited Successfully!", "", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
- }
- private void Remove_Click(object sender, EventArgs e)
- {
- SqlConnection con = new SqlConnection("Data Source=(LocalDB)\\MSSQLLocalDB;AttachDbFilename=C:\\Users\\mihai\\source\\repos\\ChainOfStores\\ChainOfStores\\Database1.mdf;Integrated Security=True");
- con.Open();
- SqlCommand cmd = new SqlCommand("DELETE FROM Store WHERE Company=@Company",con);
- cmd.Parameters.AddWithValue("@Company", Company.Text);
- cmd.ExecuteNonQuery();
- con.Close();
- MessageBox.Show("Removed Successfully!", "", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
- }
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement