Input string was not in a correct format.

Server Error in '/Build' Application.

---

Input string was not in a correct format.

[FormatException: Input string was not in a correct format.]
   System.Number.StringToNumber(String str, NumberStyles options, NumberBuffer& number, NumberFormatInfo info, Boolean parseDecimal) +2755599
   System.Number.ParseInt32(String s, NumberStyles style, NumberFormatInfo info) +112
   System.String.System.IConvertible.ToInt32(IFormatProvider provider) +43
   System.Convert.ChangeType(Object value, TypeCode typeCode, IFormatProvider provider) +293
   System.Web.UI.WebControls.Parameter.GetValue(Object value, String defaultValue, TypeCode type, Boolean convertEmptyStringToNull, Boolean ignoreNullableTypeChanges) +264
   System.Web.UI.WebControls.Parameter.get_ParameterValue() +66
   System.Web.UI.WebControls.ParameterCollection.GetValues(HttpContext context

Here is my code:

Imports System.Data
Imports System.Data.SqlClient
Partial Class Admin_Default
    Inherits System.Web.UI.Page
    Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
        ' DropDownList1.Items.Insert(0, "choose me!")
        BindData()
    End Sub
    Sub BindData()

        '1. Create a connection

              Dim myConnection As New SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings("hallam-cmsConnectionString").ConnectionString)

        '2. Create the command object, passing in the SQL string
        Const strSQL As String = "SELECT PageID, PageName FROM Pages"
        Dim myCommand As New SqlCommand(strSQL, myConnection)

        myConnection.Open()
        '3. Create the DataReader
        Dim objDR As SqlDataReader
        objDR = myCommand.ExecuteReader(CommandBehavior.CloseConnection)

        'Databind the DataReader to the listbox Web control
        DropDownList1.DataSource = objDR
        DropDownList1.DataBind()

        'Add a new listitem to the beginning of the listitemcollection
        DropDownList1.Items.Insert(0, New ListItem("-- Choose a Page --"))

    End Sub


    Protected Sub DropDownList1_SelectedIndexChanged(ByVal sender As Object, ByVal e As System.EventArgs) Handles DropDownList1.SelectedIndexChanged
        Dim dv As DataView
        Dim PageType As Integer
        dv = CType(SqlDataSource3.Select(DataSourceSelectArguments.Empty), DataView)
        PageType = CType(dv.Table.Rows(0)(0), Integer)
        If (PageType = 2) Then
            Image1.ImageUrl = "~/images/dev-diag.gif"
        Else
            Image1.ImageUrl = "~/images/dev-diag-sidebar.gif"
        End If
    End Sub
End Class

Any ideas, thanks

Andy

Here is the culprit:

'DropDownList1.Items.Insert(0, New ListItem("-- Choose a Page --"))

What's wrong with it though?

Andy

We can't debug it bcoz we dnt have database but this is very common problem

we get this error when our query is wrong somewwhere or our input don't match to query

why dont u simpley write:

DropDownList1.Items.Insert(0, "Some Text")

use DropDownList1.Items.Insert(0, "-- Choose a Page --")

Could it be because you are not assigning the DataTextField and DataValueFields for your DropDownList?  When I run your code I don't get your error, but the DropDownList doesn't contain the data I would expect.

        DropDownList1.DataTextField = "PageName"
        DropDownList1.DataValueField = "PageID"

Try something along these lines:

Sub AddListItem(ByRef objDDL as DropDownList, sText as string, sValue as string)

            dim lItem as new ListItem(sText, sValue)

            objDDL.items.add(lItem)

End Sub

The problem is:

The dropdownlist, if I add another item with   not the right type then it throws a wobbly.

sorted with

<asp:DropDownList ID="DropDownList1" runat="server"  
                    DataTextField="PageName" DataValueField="PageID"
                    DataSourceID="SqlDataSource1" AppendDataBoundItems="true" AutoPostBack="True">
       <asp:ListItem Selected="True" Value ="">Choose a Page</asp:ListItem>
    </asp:DropDownList>

Protected Sub SqlDataSource2_Selecting(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.SqlDataSourceSelectingEventArgs) Handles SqlDataSource2.Selecting
        If Not Page.IsPostBack Then
            e.Cancel = True
        End If
    End Sub

Problem is that now if I choose the 'choose a page' item after the sqldatasource2 has started binding then I get an 'object not set to instance of an object' because another piece of code:

Protected Sub DropDownList1_SelectedIndexChanged(ByVal sender As Object, ByVal e As System.EventArgs) Handles DropDownList1.SelectedIndexChanged
        Dim dv As DataView
        Dim PageType As Integer
        dv = CType(SqlDataSource3.Select(DataSourceSelectArguments.Empty), DataView)
        PageType = CType(dv.Table.Rows(0)(0), Integer)
        If (PageType = 2) Then
            Image1.ImageUrl = "~/images/dev-diag.gif"
        Else
            Image1.ImageUrl = "~/images/dev-diag-sidebar.gif"
        End If
    End Sub

Is looking for a value for that item... So I'm thinking to alter tha stored procedure for the sqldatasource3 so it only fires if not null??... is that possible in SQL?

Andy

Hi,

Andy

ajw:

'2. Create the command object, passing in the SQL string
        Const strSQL As String = "SELECT PageID, PageName FROM Pages"
        Dim myCommand As New SqlCommand(strSQL, myConnection)

        myConnection.Open()
        '3. Create the DataReader
        Dim objDR As SqlDataReader
        objDR = myCommand.ExecuteReader(CommandBehavior.CloseConnection)

        'Databind the DataReader to the listbox Web control
        DropDownList1.DataSource = objDR
        DropDownList1.DataBind()

        'Add a new listitem to the beginning of the listitemcollection
        DropDownList1.Items.Insert(0, New ListItem("-- Choose a Page --"))

If we use like following then???

----------------------------------

con.Open()

Dim com As New SqlCommand("SELECT PageID, PageName FROM Pages",myConnection)

myConnection.Open()

Dim i As Int32 = 1

DropDownList1.Items.Clear()

DropDownList1.Items.Add("-- Choose a Page --")

DropDownList1.Items(0).Value = "0000"

Dim objDR As SqlDataReader

objDR = com.ExecuteReader(CommandBehavior.CloseConnection)

While objDR.Read()

    DropDownList1.Items.Add(objDR(1).ToString())

    DropDownList1.Items(i).Value = objDR(0).ToString()

    i = i + 1

End While

objDR.Close()

Think about that both Data Text and Value fields are here.

Thanks..