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;
- using System.Data;
- namespace Chain_of_Stores
- {
- public partial class Form1 : Form
- {
- public Form1()
- {
- InitializeComponent();
- }
- private void Insert(object sender, EventArgs e)
- {
- 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");
- 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("Successfully added into table!");
- }
- private void Select(object sender, EventArgs e)
- {
- 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");
- con.Open();
- SqlCommand cmd = new SqlCommand("SELECT * FROM Store WHERE Shareholding>=50 AND Invested>=100000", con);
- SqlDataAdapter da = new SqlDataAdapter(cmd);
- DataTable dt = new DataTable();
- da.Fill(dt);
- dataGridView1.DataSource = dt;
- con.Close();
- }
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement