VB.net to SQL Server: How do you pass parameters?

[Lokean]

Hi folks,

My knowledge of VB.net has grown by leaps and bounds the past few weeks, but I am stuck on this one.

I need to pass several values to a SQL server function, then import the results into my application.

My question is twofold....

1)How do I pass parameters to the function through my VB.net code.
2)How do I return the generated table to my VB.net application.

Any help would be GREATLY appreciated. Any tutorials out there?

[Frinavale]

Hi folks,

My knowledge of VB.net has grown by leaps and bounds the past few weeks, but I am stuck on this one.

I need to pass several values to a SQL server function, then import the results into my application.

My question is twofold....

1)How do I pass parameters to the function through my VB.net code.
2)How do I return the generated table to my VB.net application.

Any help would be GREATLY appreciated. Any tutorials out there?

Hi Lokean!

Check out this resource and see if it helps you.

Cheers!

-Frinny

[Lokean]

Great!!!

Thanks!!!!!