By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,988 Members | 1,350 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,988 IT Pros & Developers. It's quick & easy.

How to retrive the records for parricular User in v.b 6.0

P: 31
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,Qty,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
Apr 17 '08 #1
Share this Question
Share on Google+
1 Reply


debasisdas
Expert 5K+
P: 8,127
You need to pass the invNo dynamically to the SQL query using IN clause and refresh the recordset and populate in grid.
Apr 17 '08 #2

Post your reply

Sign in to post your reply or Sign up for a free account.