how to display the particular user records in datagrid in vb 6.0

[hussainiyad]

Hi all,

Can anyone tell me how to get a record for particular user or Number
In my sql i,v Pinvoice table following fields

InvNo int
1001

ItemNo
001
002
003

Descrption varchar(20)
Fan
Chair
Table

Price float
90
100
20

Qty
2
5
10
Gross
180
500
200

so my question is if type the InvNo(1001) in a textbox this all Records(ItemNo, Descrp,Price,Qt y,Gross) i need to display in a grid if i type the another Invno then it has to show me the corresponding InvNo whch i specify in the same grid and in below the Grid i need the total for the
Gross amount , so can anyone tell me how to do this

[jeffstl]

Have you attempted a query yet to accomplish this?

If so what is the error you are getting? I could probably help more if I knew what the issue was with your code. Or had a query to look at and point out specific problems.