Accessing SQL Server Stored Procedure from VB.NET

[crisp99]

Hi,

I have a SQL Stored Procedure :

CREATE PROCEDURE spFilterOne
@city varchar(25)
AS
SELECT * FROM tblCities
WHERE tblCities.strCity = @city
ORDER BY tblCities.strName
In VB.NET, I would like to create a hashtable and add a key, which will be
sent to the stored procedure, as parameter @city

Dim hsParams As Hashtable
hsParams.Add("@param1", "London")
My Question :

How can I execute this stored procedure, with the hashtable giving the
parameter, from VB.NET? Once execute, I can put the rows into a dataset, that
works fine.. but its just executing the stored procedure. Thanks!!

[W.G. Ryan eMVP]

crisp - you can just create a command object and populate its Paramaters
collection - it gets you to the same place.

--
W.G. Ryan MVP (Windows Embedded)

TiBA Solutions
www.tibasolutions.com | www.devbuzz.com | www.knowdotnet.com
"crisp99" <cr*****@discussions.microsoft.com> wrote in message
news:00**********************************@microsof t.com...

Hi,

I have a SQL Stored Procedure :

CREATE PROCEDURE spFilterOne
@city varchar(25)
AS
SELECT * FROM tblCities
WHERE tblCities.strCity = @city
ORDER BY tblCities.strName
In VB.NET, I would like to create a hashtable and add a key, which will be
sent to the stored procedure, as parameter @city

Dim hsParams As Hashtable
hsParams.Add("@param1", "London")
My Question :

How can I execute this stored procedure, with the hashtable giving the
parameter, from VB.NET? Once execute, I can put the rows into a dataset, that works fine.. but its just executing the stored procedure. Thanks!!