Advertisement
AleksandarH

C#/SQL

Nov 9th, 2022
1,191
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
C# 2.10 KB | None | 0 0
  1. using System.Drawing;
  2. using System.Linq;
  3. using System.Text;
  4. using System.Windows.Forms;
  5. using System.Data.SqlClient;
  6. using System.Data;
  7.  
  8. namespace Chain_of_Stores
  9. {
  10.     public partial class Form1 : Form
  11.     {
  12.         public Form1()
  13.         {
  14.             InitializeComponent();
  15.         }
  16.  
  17.         private void Insert(object sender, EventArgs e)
  18.         {
  19.             SqlConnection con = new SqlConnection("Data Source=(LocalDB)\\MSSQLLocalDB;AttachDbFilename=C:\\Users\\Aleksandar\\source\\repos\\Chain_of_Stores\\Chain_of_Stores\\Database.mdf;Integrated Security=True");
  20.             con.Open();
  21.             SqlCommand cmd = new SqlCommand("INSERT INTO Store VALUES (@Company,@FullName,@Address,@Manufacturer,@Invested,@Shareholding,@Number,@Registration)", con);
  22.             cmd.Parameters.AddWithValue("@Company", Company.Text);
  23.             cmd.Parameters.AddWithValue("@FullName", fullName.Text);
  24.             cmd.Parameters.AddWithValue("@Address", Address.Text);
  25.             cmd.Parameters.AddWithValue("@Manufacturer", Manufacturer.Text);
  26.             cmd.Parameters.AddWithValue("@Invested", Invested.Text);
  27.             cmd.Parameters.AddWithValue("@Shareholding", Shareholding.Text);
  28.             cmd.Parameters.AddWithValue("@Number", Number.Text);
  29.             cmd.Parameters.AddWithValue("@Registration", Registration.Text);
  30.             cmd.ExecuteNonQuery();
  31.             con.Close();
  32.             MessageBox.Show("Successfully added into table!");
  33.         }
  34.  
  35.         private void Select(object sender, EventArgs e)
  36.         {
  37.             SqlConnection con = new SqlConnection("Data Source=(LocalDB)\\MSSQLLocalDB;AttachDbFilename=C:\\Users\\Aleksandar\\source\\repos\\Chain_of_Stores\\Chain_of_Stores\\Database.mdf;Integrated Security=True");
  38.             con.Open();
  39.             SqlCommand cmd = new SqlCommand("SELECT * FROM Store WHERE Shareholding>=50 AND Invested>=100000", con);
  40.             SqlDataAdapter da = new SqlDataAdapter(cmd);
  41.             DataTable dt = new DataTable();
  42.             da.Fill(dt);
  43.             dataGridView1.DataSource = dt;
  44.             con.Close();
  45.         }
  46.     }
  47. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement