Hi,

I have a small function tcontactsfetch

create function tcontactsfetch(@pID int
as return table
return(select landlineno as phoneno,
mobileno as mobileno,
workno as workno,
address as address
from tcontacts where id = @pid)

The function has been created in sql server 2000

what i want now.I want to call this function

from vb.net.How to call this function
I have to accomodiate these values into
a textbox.

any help will be appreciated.


Thanks and regards
Bali