Store Management System Using C#
Store Management System Using C#
Thank you for watching :)
Please like and subscribe
Source Code
Insert Code
SqlConnection con = new SqlConnection(@"Data Source=DESKTOP-HEEKBHE\SQLEXPRESS;Initial Catalog=StoreDB;Integrated Security=True;Trusted_Connection=True;TrustServerCertificate=True");
con.Open();
SqlCommand cnn = new SqlCommand("insert into store(id,product,quantity,price,datecreated) values(@id,@product,@quantity,@price,@datecreated)", con);
cnn.Parameters.AddWithValue("@ID", int.Parse(textBox1.Text));
cnn.Parameters.AddWithValue("@Product", comboBox1.GetItemText(comboBox1.SelectedItem));
cnn.Parameters.AddWithValue("@Quantity", comboBox2.GetItemText(comboBox2.SelectedItem));
cnn.Parameters.AddWithValue("@Price", int.Parse(textBox2.Text));
cnn.Parameters.AddWithValue("@DateCreated", dateTimePicker1.Value);
cnn.ExecuteNonQuery();
con.Close();
MessageBox.Show("Record Inserted");
ShowData();
void ShowData()
{
SqlConnection con = new SqlConnection(@"Data Source=DESKTOP-HEEKBHE\SQLEXPRESS;Initial Catalog=StoreDB;Integrated Security=True;Trusted_Connection=True;TrustServerCertificate=True");
SqlCommand cnn = new SqlCommand("select * from store", con);
SqlDataAdapter da = new SqlDataAdapter(cnn);
DataTable table = new DataTable();
da.Fill(table);
dataGridView1.DataSource = table;
}
Delete Code
SqlConnection con = new SqlConnection(@"Data Source=DESKTOP-HEEKBHE\SQLEXPRESS;Initial Catalog=StoreDB;Integrated Security=True;Trusted_Connection=True;TrustServerCertificate=True");
con.Open();
SqlCommand cnn = new SqlCommand("delete store where id=@id", con);
cnn.Parameters.AddWithValue("@Id", int.Parse(textBox1.Text));
cnn.ExecuteNonQuery();
con.Close();
MessageBox.Show("Record Deleted");
ShowData();
Search Code
SqlConnection con = new SqlConnection(@"Data Source=DESKTOP-HEEKBHE\SQLEXPRESS;Initial Catalog=StoreDB;Integrated Security=True;Trusted_Connection=True;TrustServerCertificate=True");
con.Open();
SqlCommand cnn = new SqlCommand("select * from store where id=@id", con);
cnn.Parameters.AddWithValue("@Id", int.Parse(txtSearch.Text));
SqlDataAdapter da = new SqlDataAdapter(cnn);
DataTable table = new DataTable();
da.Fill(table);
con.Close();
dataGridView1.DataSource = table;
Watch video Store Management System Using C# online without registration, duration hours minute second in high quality. This video was added by user My Coding Project 19 June 2024, don't forget to share it with your friends and acquaintances, it has been viewed on our site 355 once and liked it 6 people.