Well, My code is working fine I just need a way to reset the DataAdapter1 into 0 (like reset) So if the user hit the button search 2 times to shows up only 1 time the elements of database "product".. If i used the code below and hit 2 times the button the DataGridView show 10 product for examplat the first time and +10 for the second, a total of 20 products, even if I search then edit a product and search again it's fixed the previous table and prints again 2 times the table....
DataAdapter1.SelectCommand = Sql2 ''database load DataAdapter1.Fill(ds2, "products") ''dataset DataGridView1.DataSource = ds2 DataGridView1.DataMember = "products" SQLConnection.Close()
Thank you very much for all your help!!!