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

how to display the particular user records in datagrid in vb 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 19 '08 #1
Share this Question
Share on Google+
1 Reply


jeffstl
Expert 100+
P: 432
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.
Apr 21 '08 #2

Post your reply

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