How can I pass a SelectedValue from a Drop Down List to a Stored Procedure

[Jeff Thur]

I am running a SQL Stored Procedure that will give the
user a count of how many records are in the database as
per certain criteria.
I'm using the Execute Scalar Method.
I have no problem passing values that the user inputs
into Text boxes to my Stored Procedure. However I have a
drop down list with a listing of the individual States,
which the user selects. I am trying to use the
SelectedValue of the drop down list but I am getting a
message that SelectedValue is not a member of the
parameter collection. Would anybody know how to pass that
parameter to the Stored procedure. Below is a piece of
the program to look at. Thanks for any help that can be
provided.
Sub GetCount

Dim MyConnection As SqlConnection
MyConnection = New SqlConnection(" server='(local) '; user
id='sa'; password='fritz '; database='Cutis '")
Dim testCMD As SqlCommand = New SqlCommand ("EMSCOUNTER ",
MyConnection)
testCMD.Command Type = CommandType.Sto redProcedure

Dim Last As SqlParameter = testCMD.Paramet ers.Add
("@Last", SqlDbType.VarCh ar, 6)
Last.Value = TxtLast.Text

Dim First As SqlParameter = testCMD.Paramet ers.Add
("@First", SqlDbType.VarCh ar, 1)
First.Value = TxtFirst.Text

Dim Subscr As SqlParameter = testCMD.Paramet ers.Add
("@Subscr", SqlDbType.VarCh ar, 10)
Subscr.Value = TxtSubscr.Text

Dim State As SqlParameter = testCMD.Paramet ers.Add
("@State", SqlDbType.VarCh ar, 2)
State.Value = State.SelectedV alue
MyConnection.Op en()

TxtCount.Text = testcmd.Execute Scalar()
MyConnection.Cl ose()
End Sub

[Bernie Yaeger]

Hi Jeff,

Use cbname.selected item. But you have .state.selected value - is 'state' the
name of your combobox? If it is, change it, because it's conficting with
the name of the parameter.

HTH,

Bernie Yaeger
"Jeff Thur" <je**@emscirc.c om> wrote in message
news:4d******** *************** *****@phx.gbl.. .

I am running a SQL Stored Procedure that will give the
user a count of how many records are in the database as
per certain criteria.
I'm using the Execute Scalar Method.
I have no problem passing values that the user inputs
into Text boxes to my Stored Procedure. However I have a
drop down list with a listing of the individual States,
which the user selects. I am trying to use the
SelectedValue of the drop down list but I am getting a
message that SelectedValue is not a member of the
parameter collection. Would anybody know how to pass that
parameter to the Stored procedure. Below is a piece of
the program to look at. Thanks for any help that can be
provided.
Sub GetCount

Dim MyConnection As SqlConnection
MyConnection = New SqlConnection(" server='(local) '; user
id='sa'; password='fritz '; database='Cutis '")
Dim testCMD As SqlCommand = New SqlCommand ("EMSCOUNTER ",
MyConnection)
testCMD.Command Type = CommandType.Sto redProcedure

Dim Last As SqlParameter = testCMD.Paramet ers.Add
("@Last", SqlDbType.VarCh ar, 6)
Last.Value = TxtLast.Text

Dim First As SqlParameter = testCMD.Paramet ers.Add
("@First", SqlDbType.VarCh ar, 1)
First.Value = TxtFirst.Text

Dim Subscr As SqlParameter = testCMD.Paramet ers.Add
("@Subscr", SqlDbType.VarCh ar, 10)
Subscr.Value = TxtSubscr.Text

Dim State As SqlParameter = testCMD.Paramet ers.Add
("@State", SqlDbType.VarCh ar, 2)
State.Value = State.SelectedV alue
MyConnection.Op en()

TxtCount.Text = testcmd.Execute Scalar()
MyConnection.Cl ose()
End Sub

-----Original Message-----
Hi Jeff,

Use cbname.selected item. But you have .state.selected value - is 'state' thename of your combobox? If it is, change it, because it's conficting withthe name of the parameter.

HTH,

Bernie Yaeger
Hi Bernie,
Thats it. Also Would you know
How can I select multiple States from the drop down box
and pass them on to my SQL Query.

Thank You VERY MUCH.

Jeff...........
"Jeff Thur" <je**@emscirc.c om> wrote in message
news:4d******* *************** ******@phx.gbl. ..

I am running a SQL Stored Procedure that will give the
user a count of how many records are in the database as
per certain criteria.
I'm using the Execute Scalar Method.
I have no problem passing values that the user inputs
into Text boxes to my Stored Procedure. However I have a drop down list with a listing of the individual States,
which the user selects. I am trying to use the
SelectedValue of the drop down list but I am getting a
message that SelectedValue is not a member of the
parameter collection. Would anybody know how to pass that parameter to the Stored procedure. Below is a piece of
the program to look at. Thanks for any help that can be
provided.
Sub GetCount

Dim MyConnection As SqlConnection
MyConnection = New SqlConnection(" server='(local) '; user id='sa'; password='fritz '; database='Cutis '")
Dim testCMD As SqlCommand = New SqlCommand ("EMSCOUNTER ", MyConnection)
testCMD.Command Type = CommandType.Sto redProcedure

Dim Last As SqlParameter = testCMD.Paramet ers.Add
("@Last", SqlDbType.VarCh ar, 6)
Last.Value = TxtLast.Text

Dim First As SqlParameter = testCMD.Paramet ers.Add
("@First", SqlDbType.VarCh ar, 1)
First.Value = TxtFirst.Text

Dim Subscr As SqlParameter = testCMD.Paramet ers.Add
("@Subscr", SqlDbType.VarCh ar, 10)
Subscr.Value = TxtSubscr.Text

Dim State As SqlParameter = testCMD.Paramet ers.Add
("@State", SqlDbType.VarCh ar, 2)
State.Value = State.SelectedV alue
MyConnection.Op en()

TxtCount.Text = testcmd.Execute Scalar()
MyConnection.Cl ose()
End Sub

.