Search:

I have a datagridview, and when i use scrollbar the columns shown over the others, like this image:

159965

i have tried DoubleBuffered like that:

1- i created a module named...

Great
I used it by that way:


Sql = "select ItemCode, FirstUnit AS Unit, ItemName from Items where Status='True' and FirstUnitBarcode+ItemName like N'%" & SearchText.Text.Trim & "%" & "' UNION...

Yes, i got the idea, i'll try it now

Thank you
you're right
i'll do that in another projects

Thank you
i'll try it
but this

With SourceBS
.DataSource = SourceDT
.AddNew()
DirectCast(.Current, DataRowView)("ItemCode") = 1
...

Thank you very much
Worked like a charm
another question: if the item have only two Units, its shown 3 rows in datagridview for that item, one of that rows have empty column in Unit column .
how...

Hello,
this is my SQL Table:

159913

i need to add all 3 units for the items in the same DataGridView with new rows if the item already have 3 units like this:

159915

I have tried this: