Setting DropDownList to a Default Value?????

[Patrick Olurotimi Ige]

I have a DropDown Lsit set to
ddlGetDebtor.It ems.Insert(0, "-Select Debtor Code-")
which is setting the "-Select Debtor Code-" to be default

And on PostBack i'm passng:-
Cmd.Parameters. Add(New SqlParameter("@ DebtorCodeID",
ddlGetDebtor.Se lectedItem.Valu e))

to to retrieve the Data

DebtorCodeID is an integer
But when somebody selects a Value and does a Postback and gets back to
"Select Debtor Code" and select it it RETURNS an error!:-

System.Data.Sql Client.SqlExcep tion: Error converting data type nvarchar
to int. at
System.Data.Sql Client.SqlComma nd.ExecuteReade r(CommandBehavi or
cmdBehavior, RunBehavior runBehavior, Boolean returnStream) at
System.Data.Sql Client.SqlComma nd.ExecuteReade r() at
Online_Ordering .CheckOut.FillA ll(Object sender, EventArgs e) in
c:\inetpub\wwwr oot\Online_Orde ring\CheckOut.a spx.vb:line 209

*** Sent via Developersdex http://www.developersdex.com ***

[charmis p varghese]

Hi Patrick

try the code below

private void dropdownlist_Se lectedIndexChan ged(object sender,
System.EventArg s e)
{

if( dropdownlist.Se lectedIndex > 0 )
{
//Do the database operation only when the selectedindex is greater than
0
}

}
regards
charmis

[DevGuy]

Try this:
Cmd.Parameters. Add(New SqlParameter("@ DebtorCodeID",

ddlGetDebtor.Se lectedItem.Valu e.ToString))
--
There is always a way
"Patrick Olurotimi Ige" wrote:
I have a DropDown Lsit set to
ddlGetDebtor.It ems.Insert(0, "-Select Debtor Code-")
which is setting the "-Select Debtor Code-" to be default

And on PostBack i'm passng:-
Cmd.Parameters. Add(New SqlParameter("@ DebtorCodeID",
ddlGetDebtor.Se lectedItem.Valu e))

to to retrieve the Data

DebtorCodeID is an integer
But when somebody selects a Value and does a Postback and gets back to
"Select Debtor Code" and select it it RETURNS an error!:-

System.Data.Sql Client.SqlExcep tion: Error converting data type nvarchar
to int. at
System.Data.Sql Client.SqlComma nd.ExecuteReade r(CommandBehavi or
cmdBehavior, RunBehavior runBehavior, Boolean returnStream) at
System.Data.Sql Client.SqlComma nd.ExecuteReade r() at
Online_Ordering .CheckOut.FillA ll(Object sender, EventArgs e) in
c:\inetpub\wwwr oot\Online_Orde ring\CheckOut.a spx.vb:line 209

*** Sent via Developersdex http://www.developersdex.com ***

[Patrick.O.Ige]

Thx Mate

"charmis p varghese" wrote:

Hi Patrick

try the code below

private void dropdownlist_Se lectedIndexChan ged(object sender,
System.EventArg s e)
{

if( dropdownlist.Se lectedIndex > 0 )
{
//Do the database operation only when the selectedindex is greater than
0
}

}
regards
charmis

[Patrick Olurotimi Ige]

Hi DevGuy thx for the reply but using:-
Cmd.Parameters. Add(New SqlParameter("@ DebtorCodeID",

ddlGetDebtor.Se lectedItem.Valu e.ToString))

Still give the same error!!!

Whereas Charmis advice is good but in my case i'm using
NextResults() like so below:-

How should i use the

If DropDown.Select edIndex > 0 Then
EndIf
Without affecting the "objDR.NextResu lt()"

Code Below:--
------------------
Try

MyConn.Open()
objDR = Cmd.ExecuteRead er

ddlFill1.DataSo urce = objDR
ddlFill1.DataVa lueField = "AddressID"
ddlFill1.DataTe xtField = "Suburb"
ddlFill1.DataBi nd()

objDR.NextResul t()


ddlFill2.DataSo urce = objDR
ddlFill2.DataVa lueField = "AddressID"
ddlFill2.DataTe xtField = "Suburb"
ddlFill2.DataBi nd()
'ddlFill2.Items .Insert(0, "-Select Delivey Address-")

objDR.NextResul t()
With ddlFill3
.DataSource = objDR
.DataValueField = "AddressID"
.DataTextField = "Suburb"
.DataBind()
'ddlFill3.Items .Insert(0, "-Select Billing Address-")
End With

objDR.NextResul t()

With ddlFill4
.DataSource = objDR
.DataValueField = "TelstraAcc ID"
.DataTextField = "TelstraAcc No"
.DataBind()
End With

ddlFill1.Items. Insert(0, "-Select Site Address-")
ddlFill2.Items. Insert(0, "-Select Delivey Address-")
ddlFill3.Items. Insert(0, "-Select Billing Address-")

Catch ex As SqlException
Response.Write( ex.ToString)
Finally

If Not (objDR Is Nothing) Then
objDR.Close()

End If

MyConn.Dispose( )
End Try

*** Sent via Developersdex http://www.developersdex.com ***