Using stored procedure as listbox recordsource

[doraemon18]

i have a SP that goes like this..

Create proc policy_details
@policy_num as integer

select policy_number,amount_insured
FROM policy INNER JOIN policy_details ON policy.policy_number = policy_details.policy_number
WHERE policy_number = @policy_num
go

I also have a listbox on the form and i want to use the stored procedure "policy_details" to populate the listbox.can anyone help me?

 

[BuGlen]

Not knowing which platform you're client is running, it's difficult to give any particulars in the example. However, generally speaking you can retrieve the results of the SP into a recordset or dataset object and bind the listbox control to data object.

If you post more specifics on your situation, someone with more experience in your environment may be able to give more helpful examples.


Glen Appleton

VB.Net student.