How to View Results from a Stored Procedure in a Listbox

[gayano]

Hi I'm Tried Lot's of forums but still no Answer
Can you guys help me?

What i have is a Stored procedure looks like this

ALTER PROCEDURE dbo.DriveSearch

@Driver varchar(50)
AS
SELECT Name,Furi
FROM Driver
WHERE Furi Like @Driver + '%'

And in the user end

I have a form which includes a textbox, button, and a listbox

all i wanna do is get the results from the stored procedure and show it in　the listbox

p/s user inputs the parameter(@driver) using the textbox and the button is for execute the stored procedure.

can anyone help me in this??


P/s Im using sql 2005 express and visual studio 2005 .net

Thank you

[gayano]

Please Anybody help
I'm stuck here

[gahoi]

Hi I'm Tried Lot's of forums but still no Answer
Can you guys help me?

What i have is a Stored procedure looks like this

ALTER PROCEDURE dbo.DriveSearch

@Driver varchar(50)
AS
SELECT Name,Furi
FROM Driver
WHERE Furi Like @Driver + '%'

And in the user end

I have a form which includes a textbox, button, and a listbox

all i wanna do is get the results from the stored procedure and show it in　the listbox

p/s user inputs the parameter(@driver) using the textbox and the button is for execute the stored procedure.

can anyone help me in this??


P/s Im using sql 2005 express and visual studio 2005 .net

Thank you

=======
dear
first think you use the listbox or listview
if you use list box
ans is
select query run in this time and
cmd=new sqlcommand(sqlname, connection name)
cmd.exucatereader
while daread.read then
textbox.text= daread("dataname")
textbox.text=daread("dataname")
listbox.text=daread("dataname")
end while
and you use the list view
then

select query run in this time and
cmd=new sqlcommand(sqlname, connection name)
cmd.exucatereader
while daread.read then
dim lv as string
dim i as interger
dim lv as new listviewitem.count-1
for each i=0 to i=lv.count-1
listview.items(i).subitems(0).add("dataname")



next
endif

[gayano]

Thnks I try it
Thanks for your help

[gayano]

sorry gahoi
I dont understand your english
Can you please try to explain it to me again??