DataGridView search function not working perfectly

Question

Sir I am in Windows form mini project. My issue is search function in DataGridView with a TextBox is not working perfectly; gridview is filling  but with a duplicate row. this is SQL Query : - c# code :- result before search function:- and the result after search function : -

Nishant Mittal · Answer

I can see the problem is in your code 1st y u have used for loop when u r using datagridView1.datasource = ds.table[0] Only this statment will do job for u...no need of for loop :) By this way u can avoid duplicate column

Bineesh VP · Answer

#Nishant You gave me a good suggestion and my code in now working perfectly. Here the modified code:- here the result:-

Nishant Mittal · Answer

The question is itself not right..How we can give answer lol :)

Ranjit Powar · Answer

Remove previous row by dataGridView1.Rows.Clear() And then add new rows in for loop like dataGridView1.Rows.Add();

Ranjit Powar · Answer

Either assign datasource property or clear previous rows and add new rows in for loop. You are doing both that is wrong.

Bineesh VP · Answer

#Nishant The columns has been repeated one more time. you can see productIdProductName etc. are displayed two times in same row. I know that these are came because I wrote dataGridView1.DataSource=ds.Tables[0]; and also assigned the dataset values into the gridcolumns. So both result is being displayed there. I removed the code piece dataGridView1.DataSource=ds.Tables[0]; and still no change in gridview display and are like this:

Shakti Singh Dulawat · Answer

As I can see you don't have duplicate rows all you have duplicates columns

Nishant Mittal · Answer

Where are duplicate values :)

Shakti Singh Dulawat · Answer

Make sure you have AutoGenerateColumns= false ;