DataGridView search function not working perfectly

Bineesh Viswanath

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 : -

9 Replies

Know the answer? Post it — somebody with the same question will find it here.

Nishant Mittal10y ago
Accepted 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
+2
Bineesh Viswanath10y ago
#Nishant,
You gave me a good suggestion and my code in now working perfectly. Here the modified code:-

here the result:-
0
Nishant Mittal10y ago
The question is itself not right..How we can give answer lol :)
0
Ranjit Powar10y ago
Remove previous row by
dataGridView1.Rows.Clear()
And then add new rows in for loop like
dataGridView1.Rows.Add();
0
Ranjit Powar10y ago
Either assign datasource property or clear previous rows and add new rows in for loop. You are doing both that is wrong.
0
Bineesh Viswanath10y ago
#Nishant
The columns has been repeated one more time. you can see productId,ProductName 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 piecedataGridView1.DataSource=ds.Tables[0]; and still no change in gridview display and are like this:
0
Shakti Singh Dulawat10y ago
As I can see you don't have duplicate rows all you have duplicates columns
0
Nishant Mittal10y ago
Where are duplicate values :)
0
Shakti Singh Dulawat10y ago
Make sure you have
AutoGenerateColumns=false;
0

DataGridView search function not working perfectly

The columns has been repeated one more time. you can see productId,ProductName etc. are displayed two times in same row.