[Solved] How to stop duplicating the data in database everytime the form loads?
[ad_1] I don’t understand the need of your “reports” table,… If I was you I’ll use only ShowData() with the query, like this public void ShowData() { con = new SqlConnection(@”Data Source=LAPTOP-KA7UGSG3;Initial Catalog=JAPoultry;Integrated Security=True”); con.Open(); da = new SqlDataAdapter(“SELECT Variety, SUM(Quantity) FROM Inventory GROUP BY Variety”, con); dt = new DataTable(); da.Fill(dt); dgv_Reports.DataSource = dt; … Read more