Member Avatar for like_bilal02

Dear Freinds i want to show mulitple rows of sql server in which bill_no are same to show in datagrid view when i want to edit anything in data
and i show the data in datagrid view with the help of bill_no

but when i search the data by bill no its show only one row and not show other row with same bill no so please help me

my coding is

For abc = 0 To DataGridView1.Rows.Count - 1 
Dim mydataa = From z In edtpur.purchaseitems Select z _ 
Where z.bill_no = Val(ComboBox1.Text) 
DataGridView1.Rows(abc).Cells(0).Value = mydataa.FirstOrDefault.s_no 
DataGridView1.Rows(abc).Cells(1).Value = mydataa.FirstOrDefault.item_name
  • 2 Contributors
  • 1 Reply
  • 85 Views
  • 1 Day Discussion Span
  • Latest Post Latest Post by G_Waddell
Member Avatar for G_Waddell

Hi,

I'm sorry but I'm not 100% sure what you are trying to do.

Are you wanting to pick a bill number then see all items on the bill?

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.