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;
Смотрите видео Store Management System Using C# онлайн без регистрации, длительностью часов минут секунд в хорошем качестве. Это видео добавил пользователь My Coding Project 19 Июнь 2024, не забудьте поделиться им ссылкой с друзьями и знакомыми, на нашем сайте его посмотрели 355 раз и оно понравилось 6 людям.