• there is no 4 in the SP

    i even checked with select * from table1

    i am not sure where do i get it from but i found this on debugging

    ?cmdupdate.CommandText

    "4"

    ?cmdupdate

    {System.Data.SqlClient.SqlCommand}

    CommandText: "4"

    CommandTimeout: 30

    CommandType: Text {1}

    Connection: {System.Data.SqlClient.SqlConnection}

    Container: Nothing

    DesignTimeVisible: True

    Notification: Nothing

    NotificationAutoEnlist: True

    Parameters: {System.Data.SqlClient.SqlParameterCollection}

    Site: Nothing

    Transaction: Nothing

    UpdatedRowSource: Both {3}

    cmdupdate is the sqlcommand

    cmdupdate.CommandText = "4"

    CommandType.StoredProcedure = StoredProcedure {4}

    i get this on debugging the application