How to retrive the records for parricular User in v.b 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

[debasisdas]

You need to pass the invNo dynamically to the SQL query using IN clause and refresh the recordset and populate in grid.