Error with dropdown list

[JJ297]

I have a dropdown list populated via a database. I edited the
dropdown list to have "select a topic" to always appear when the drop
down loads. Now if a user selects a dropdown item it goes into the
datagrid fine, but if a user selects "select a topic" I get an error
message...
Error converting nvarchar to int on adapter.Fill(ds )

Here's the code behind can someone please assist? Thanks!

Protected Sub DropDownList2_S electedIndexCha nged(ByVal sender As
Object, ByVal e As System.EventArg s) Handles
DropDownList2.S electedIndexCha nged
Dim conn As New
Data.SqlClient. SqlConnection(C onfigurationMan ager.Connection Strings("TrainU serConnectionSt ring").Connecti onString)

Dim cmd As New Data.SqlClient. SqlCommand

With cmd
.CommandType = Data.CommandTyp e.StoredProcedu re

.CommandText = "Getclassificat ions1"
If DropDownList2.S electedValue = "select a topic" Then

Response.Write( "Please select a topic")

Else
.Parameters.Add WithValue("clas sificationid",
DropDownList2.S electedValue)
.Connection = conn
End If
End With

Dim adapter As New Data.SqlClient. SqlDataAdapter( cmd)
Try

conn.Open()

Dim ds As New Data.DataSet
adapter.Fill(ds )

GridView1.DataS ource = ds

GridView1.DataB ind()

Finally

conn.Close()

End Try

[smhusain1983]

Hi,
I m a c# developer..dont have idea abt vb.net syntax but
the problem seems to be in If Condition..
seems like every time control passing in else condition n so passing
nvarchar value "select a topic" to ur procedure
which takes only int value for ID "classification id" n so passing the
error messg..

just a guess..

On Jan 8, 8:30*pm, JJ297 <[e-mail] mwrote:

I have a dropdown list populated via a database. *I edited the
dropdown list to have "select a topic" to always appear when the drop
down loads. *Now if a user selects a dropdown item it goes into the
datagrid fine, but if a user selects "select a topic" *I get an error
message...
Error converting nvarchar to int on adapter.Fill(ds )

Here's the code behind can someone please assist? *Thanks!

* Protected Sub DropDownList2_S electedIndexCha nged(ByVal sender As
Object, ByVal e As System.EventArg s) Handles
DropDownList2.S electedIndexCha nged

* * * * Dim conn As New
Data.SqlClient. SqlConnection(C onfigurationMan ager.Connection Strings("TrainU *serConnectionS tring").Connect ionString)

* * * * Dim cmd As New Data.SqlClient. SqlCommand

* * * * With cmd
* * * * * * .CommandType = Data.CommandTyp e.StoredProcedu re

* * * * * * .CommandText = "Getclassificat ions1"

* * * * * * If DropDownList2.S electedValue = "select a topic" Then

* * * * * * * * Response.Write( "Please select a topic")

* * * * * * Else
* * * * * * * * .Parameters.Add WithValue("clas sificationid",
DropDownList2.S electedValue)
* * * * * * * * .Connection = conn
* * * * * * End If
* * * * End With

* * * * Dim adapter As New Data.SqlClient. SqlDataAdapter( cmd)
* * * * Try

* * * * * * conn.Open()

* * * * * * Dim ds As New Data.DataSet
* * * * * * adapter.Fill(ds )

* * * * * * GridView1.DataS ource = ds

* * * * * * GridView1.DataB ind()

* * * * Finally

* * * * * * conn.Close()

* * * * End Try

[JJ297]

On Jan 8, 11:53*am, smhusain1...@gm ail.com wrote:

Hi,
I m a c# developer..dont have idea abt vb.net syntax but
the problem seems to be in If Condition..
seems like every time control passing in else condition n so passing
nvarchar value "select a topic" to ur procedure
which takes only int value for ID "classification id" n so passing the
error messg..

just a guess..

On Jan 8, 8:30*pm, JJ297 <[e-mail] mwrote:

I have a dropdown list populated via a database. *I edited the
dropdown list to have "select a topic" to always appear when the drop
down loads. *Now if a user selects a dropdown item it goes into the
datagrid fine, but if a user selects "select a topic" *I get an error
message...
Error converting nvarchar to int on adapter.Fill(ds )

Here's the code behind can someone please assist? *Thanks!

* Protected Sub DropDownList2_S electedIndexCha nged(ByVal sender As
Object, ByVal e As System.EventArg s) Handles
DropDownList2.S electedIndexCha nged

* * * * Dim conn As New
Data.SqlClient. SqlConnection(C onfigurationMan ager.Connection Strings("TrainU **serConnection String").Connec tionString)

* * * * Dim cmd As New Data.SqlClient. SqlCommand

* * * * With cmd
* * * * * * .CommandType = Data.CommandTyp e.StoredProcedu re

* * * * * * .CommandText = "Getclassificat ions1"

* * * * * * If DropDownList2.S electedValue = "select a topic" Then

* * * * * * * * Response.Write( "Please select a topic")

* * * * * * Else
* * * * * * * * .Parameters.Add WithValue("clas sificationid",
DropDownList2.S electedValue)
* * * * * * * * .Connection = conn
* * * * * * End If
* * * * End With

* * * * Dim adapter As New Data.SqlClient. SqlDataAdapter( cmd)
* * * * Try

* * * * * * conn.Open()

* * * * * * Dim ds As New Data.DataSet
* * * * * * adapter.Fill(ds )

* * * * * * GridView1.DataS ource = ds

* * * * * * GridView1.DataB ind()

* * * * Finally

* * * * * * conn.Close()

* * * * End Try- Hide quoted text -

- Show quoted text -

Actually I solved it by adding List Item value = 0 on the asp page.
Then on the aspx page I added
If DropDownList2.S electedItem.Val ue = "0" Then
DD2.Text = ("select a topic")
End If

It works!