BinaryFormatter.Deserialize: specified cast is not valid

Hi,

I have a stored proc. When i execute this proc with correct data from front end i get no error.

However, when i execute the proc with incorrect data i am getting an error

"specified cast s not valid"

I am using SQL server 2008

and below is my proc

USE [AAVouchers_Dev02]
GO
/****** Object:  StoredProcedure [dbo].[USP_UploadData]    Script Date: 10/20/2010 13:28:08 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER proc [dbo].[USP_UploadData]
    @FileName varchar (100),
    @CorporateID bigint,
    @CreatedBy bigint,
    --@tbl_FileData tbl_FileData  READONLY
    @data Varchar(max),
    @sendMail Bit =0
 as
SET NOCOUNT ON
 
DECLARE @intError as int,
      @strError as varchar(max),
      @intFILEID int
     
     
SET  @intError = 0
SET @strError = 'No Error'


DEclare @data_xml XML = @data

   

 DECLARE @ErrorTMP TABLE(IntError bigint,StrError Varchar(250))


Begin Try
   
--check Corpor

I am having problem, Please help me guys .....

these are the errors:

Server Error in '/FYPasp' Application.
Specified cast is not valid.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.InvalidCastException: Specified cast is not valid.

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace:

[InvalidCastException: Specified cast is not valid.]
   System.Data.SqlClient.SqlBuffer.get_Int32() +5002837
   System.Data.SqlClient.SqlDataReader.GetInt32(Int32 i) +38
   Read_DynamicClass1(ObjectMaterializer`1 ) +322
   System.Data.Linq.SqlClient.ObjectReader`2.MoveNext() +32
   System.Collections.Generic.List`1..ctor(IEnumerable`1 collection) +327
   System.Linq.Enumerable.ToList(IEnumerable`1 source) +58

These are the codes:

string metric = Session["ID"].ToString();
            string status = null;
            var onlineStud = db.students.Single(s => s.metricNo.Equals(metric));

          

Hello,

I'm getting the error in the subject whenever I run my application.  I think that it may be related to this:  http://forums.asp.net/p/1038043/1438409.aspx#1438409 and since I have <compilation debug="true" />, I think setting that to false may aid not getting this, as is what it seems as if I read.  So, Is that correct, or is this related to something else?

Thanks.

I am interfacing a .NET Web Service using gSOAP. All operations in the WS take a "layout" parameter whose type is:

<xs:schema attributeFormDefault="qualified" elementFormDefault="qualified" targetNamespace="foo:bar:replaced" id="NDSLayout">
    <xs:element msdata:IsDataSet="true" msdata:UseCurrentLocale="true" name="NDSLayout">
        <xs:complexType>
            <xs:choice minOccurs="0" maxOccurs="unbounded">
                <xs:element name="Layout">
                    <xs:complexType>
                        <xs:sequence>
                            <xs:element minOccurs="0" name="FIELD" type="xs:string"/>
                            <xs:element minOccurs="0" name="INCLUDE" type="xs:boolean"/>
                            <xs:element minOccurs="0" name="CRITERIA" type="xs:string"/>
                        </xs:sequence>
                    </xs:complexType>
                </xs:element>
            </xs:choice>
        </xs:complexType>
    </xs:element>

There is a problem with your selected data store. This can be caused by an invalid server name or credentials, or by insufficient permission. It can also be caused by the role manager feature not being enabled. Click the button below to be redirected to a page where you can choose a new data store.

The following message may help in diagnosing the problem: Specified cast is not valid.

I'm not sure how it happened but after changing a column in my AccommodationComment table from memberId to username I tested it and all pages which have to do with selecting current user or any user says:

System.InvalidCastException was unhandled by user code
  Message=Specified cast is not valid.
  Source=System.Data
  StackTrace:
       at System.Data.SqlClient.SqlBuffer.get_SqlGuid()
       at System.Data.SqlClient.SqlDataReader.GetGuid(Int32 i)
       at System.Web.Security.SqlMembershipProvider.GetUser(String username, Boolean userIsOnline)
       at System.Web.Security.Membership.GetUser(String username, Boolean userIsOnline)
       at System.Web.Security.Membership.GetUser()
       at Actions.getUse

Hello all!

I'm working with VS2010 Beta2, ASP.NET and Dynamic Data. I'm using VB but will certainly be happy to receive a C# example if necessary. 

I used a few of Steve's examples (Writing Attributes and Extension Methods for Dynamic Data and Dynamic Data - Hiding Columns in selected PageTemplates) to create a custom property attribute to be applied to a dynamic data column and want it to accept an array of enum values (each value will represent a dynamic data page template where this column should not be displayed).  My new attribute works fine when I hardcode it like this, meaning the HideColumnIn attribute is properly populated with the array of enum values:

<HideColumnIn(PageTemplate.List, PageTemplate.Edit)> _
Public Property My_DD_Column As Object

However, I want to store the values to be used for the HideColumnIn in the DB as integer values that correspond to the

• A
• n error has occurred during report processing.
  • Exception has been thrown by the target of an invocation.
    • Failed to enable constraints. One or more rows contain values violating non-null, unique, or foreign-key constraints.

Why do I keep getting this error, even when not using any data on the report. When I run the query in SQL server I get a resultset. However when I try to render the report I get this error.

Thanks!

hi

im trying to save a file, filename as current date and time.it will give an error.

any ideas.

here is my code

string datetime=DateTime.Now.ToString();

if (GridviewtoCSV("~/Admin/doc/Reports/" + batchid.ToString() + datetime + ".csv", transactiongrid) && GridviewtoPDF("~/Admin/doc/Reports/" + batchid.ToString() + datetime + ".pdf", transactiongrid))
                {

Hello,
 Why am I getting this error on line:

               sp.Price = Convert.ToDecimal(collection.GetValue("Price"));

sp is :
  SPecials_Templates sp = new SPecials_Templates();

SPecials_Templates Defined:

    [MetadataType(typeof(SPecials_TemplatesMetaData))]
    public partial class SPecials_Templates
    {
        public class SPecials_TemplatesMetaData
        {

                [ScaffoldColumn(false)]
            public object Key { get; set; }
            [StringLength(50)]
            public object Template_Name { get; set; }
            [StringLength(12)]
            public object Headline { get; set; }
            [StringLength(12)]
    &nbs

Hello!

I'm getting  the following error message: 

Unable to cast object of type 'System.Data.Linq.DataQuery`1[Username]' to type 'Username'.

I've been searching but can't find a solution.  This particular table has 4 columns. The first column is the int indentifier.  Column 2 is "username" (varchar50) and is the primary key.  Column3 is "userID" (uniqueidentifier) and column 4 is "active" (varchar5) .

Try
            Dim dc As New DataClassesDataContext
            Dim c3 As New Username With {.userID = userGuid, _
                                    .username = userCustomName, _
                                    .active = "False"}

            dc.Usernames.InsertOnSubmit(c3)
            dc.SubmitChanges()

        Catch ex As Exception
            Throw ex
        End Try

Hi

Im receiving a strange error Error Message: Conversion from string "15/08/2010 22:21:35" to type 'Date' is not valid.

I know this is generally down to cultural date formats etc, however the reason this is strange is it just randomly occured twice in the last week, the website has been running since october and nothing has changed,

The error constantly occured until the IIS was reset and recompilled the site, its been running fine since, however im just trying to figure out what could cause such an error to occur.

I've narrowed it down to a line of code which is:

bktime = DReader.Item("Bktime").ToString

bktime = Year(CDate(bktime)) & "-" & fmt(Month(CDate(bktime)), 2) & "-" & fmt(Day(CDate(bktime)), 2)

Has anyone else encountered this randomly occuring and is there anything i can put in place to prevent this in future?


Cheers


Mike