DataSource Controls :: Invalid Cast Exception When Trying To Utilize A SQL MAX Function Within C Sharp Code?

Mar 30, 2010

The error that I get from this code states that the cast is invalid and that the number must be less than infinity. [Code]....

By the way, I tried to paste my code using the icon from the toolbar but it didn't work. Firefox problem maybe?

View 3 Replies

Similar Messages:

DataSource Controls :: SqlBulkCopy - Invalid Cast From 'System.String' To 'System.Guid'

Feb 19, 2010

I am attempting to use SqlBulkCopy to import data from an XML document. I receive the following error when executing WriteToServer: Invalid cast from 'System.String' to 'System.Guid'

View 1 Replies

Cast Exception When Try To Insert Entity In Entity Framework (using Code-f)

Feb 9, 2011

I get an cast exception when i am trying to insert an entity in Entity Framework (using code-first). From this code :

public virtual T Insert(T entity)
return Context.Set<T>().Add(entity);

The cast exception is like "impossible to cast ...Collection'1(Entity) to type (Entity)" I can't figure out why. I am pretty sure ive done everything right. Post entity

public class Post
public long PostId { get; private set; }
public DateTime date { get; set; }
public string Subject { get; set; }
public User User { get; set; }
public Category Category { get; set; }
public string Body { get; set; }
public virtual ICollection<Tag> Tags { get; private set; }
public Post()
Category = new Category();
if (Tags == null)
Tags = new Collection<Tag>();

View 9 Replies

Web Forms :: Invalid Cast From DBNull To Integer?

Jan 9, 2011

This has never happened before. It is not happening even in my visual studio. It is only happening on the live site. This never happened before on the live site either. I changed the master template but the change I made had nothing to do with the issue here. 3


Exception Details: System.InvalidCastException: Conversion from type 'DBNull' to type 'Integer' is not valid.Source Error:


Line 25: <asp:DataList ID="DataList1" runat="server" DataKeyField="AParentID" DataSourceID="ObjectDataSource1" RepeatColumns="2" ShowFooter="False" ShowHeader="False" Font-Bold="False" Font-Italic="False" Font-Overline="False" Font-Strikeout="False" Font-Underline="False" HorizontalAlign="Center" CellSpacing="0" CellPadding="0" ItemStyle-Width="225" Width="500px">
Line 26: <ItemTemplate>
Line 27: <asp:Image ID="Image1" runat="server" ImageAlign="NotSet" ImageUrl='<%# GetImage(Eval("AParentID")).ToString %>' />
Line 28: <asp:HyperLink ID="HyperLink1" runat="server" Text='<%# Indent(Eval("ACategory")).ToString() %>' NavigateUrl='<%# String.Format("articles_view_subcats.aspx?catid={0}",DataBinder.Eval(Container.DataItem,"ACategoryID")) %>' ForeColor='<%# GetFont(Convert.ToInt32(Eval("AParentID")))%>' Font-Size='<%# GetFontSize(Convert.ToInt32(Eval("AParentID"))) %>'></asp:HyperLink>
Line 29:

View 4 Replies

State Management :: Session And Object Invalid Cast

May 21, 2010

System.InvalidCastException was unhandled by user code

Message=Specified cast is not valid.

at Donate.LoadUserDetails() in C:UsersSimonDesktopLocal SitesCats ProtectionNewDonate.aspx.vb:line 261
at Donate.btnDonate30_Click(Object sender, EventArgs e) in C:UsersSimonDesktopLocal SitesCats ProtectionNewDonate.aspx.vb:line 205
at System.Web.UI.WebControls.LinkButton.OnClick(EventArgs e)
at System.Web.UI.WebControls.LinkButton.RaisePostBackEvent(String eventArgument)
at System.Web.UI.WebControls.LinkButton.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument)
at System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument)
at System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData)
at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)

I have made the important bits Bold I have the following code which is generating this error:


I am not entirely sure what is causing it. Its completley intermitent. I am storing all the details of a user filling in a form in a structure, and then assigning that structure to a session variable. This means if they page back, and then page forward again, I can pre-populate the form with the details they have already filled in for their conveinience by using the above code snippet. It appears that it works for a good minute, but if I leave the browser alone any longer than roughly 60 seconds, and then try and page forward to the form again, the exception will fire. While writing this post, the exception has occured in again in firefox, but interestingly, Google Chrome doesn't seem to have this problem. It looks like I can leave chrome alone for as long as I want and it will still work.

View 6 Replies

C# - Exception Is Like The Padding Is Invalid And Cannot Be Removed Exception?

Jul 12, 2010

We're getting this InternalSubStringWithChecks exception with our application's healthMonitoring. This exception is like the Padding is invalid and cannot be removed exception where it's being recorded and we're getting a notification email but the end user is unaware that an actual error has happened. Though we don't want our event log filled up with this rubbish! The stack trace is:

Parameter name: length
at System.String.InternalSubStringWithChecks(Int32 startIndex, Int32 length, Boolean fAlwaysCopy)
at System.Web.Handlers.AssemblyResourceLoader.System.Web.IHttpHandler.ProcessRequest

View 1 Replies

DataSource Controls :: Getting Exception / An Exception Occurred While Executing A Transact-SQL Statement Or Batch

Jan 1, 2010

i need to restore Database.mdf; I create a blank new database exactly the same name as the .mdf file. However, I could not restore the database.

The error message prompted was:

TITLE: Microsoft SQL Server Management Studio Express

An exception occurred while executing a Transact-SQL statement or batch.



Cannot open backup device 'C:inetpubwwwrootTCPSystemApp_DataDatabase.mdf'. Operating system error 32(error not found).

RESTORE HEADERONLY is terminating abnormally. (Microsoft SQL Server, Error: 3201)

click: [URL]



View 10 Replies

State Management :: Cast From Cache To Generic List Throws An Exception

Mar 17, 2011

In application. i cache a Linq to Xml result to a Cache object. when i cast the cache object back to generic list. i get the following exception.

[A]System.Collections.Generic.List`1[CarRentalAddress] cannot be cast to [B]System.Collections.Generic.List`1[CarRentalAddress]. Type A originates from 'mscorlib, Version=, Culture=neutral, PublicKeyToken=b77a5c561934e089' in the context 'LoadNeither' at location 'C:WINDOWSassemblyGAC_32mscorlib2.0.0.0__b77a5c561934e089mscorlib.dll'. Type B originates from 'mscorlib, Version=, Culture=neutral, PublicKeyToken=b77a5c561934e089' in the context 'LoadNeither' at location 'C:WINDOWSassemblyGAC_32mscorlib2.0.0.0__b77a5c561934e089mscorlib.dll'.

My code looks like this.

if (!Page.IsPostBack) { if (Cache["xml"] == null) { DataSet ds = new DataSet(); ds.ReadXml(HttpContext.Current.Server.MapPath("~/CarRentalAddress.xml")); var grid = (from d in ds.Tables[0].AsEnumerable() orderby d.Field<string>("City") where d.Field<string>("Enabled") == "1" select new CarRentalAddress { City = d.Field<string>("City"), HotelName = d.Field<string>("HotelName"), Address = d.Field<string>("Address"), EmailID1 = d.Field<string>("EmailID1"), EmailID2 = d.Field<string>("EmailID2") }).ToList(); Cache["xml"] = grid; totalrows = grid.Count().ToString(); grdAddress.DataSource = grid; grdAddress.DataBind(); } else { //Exception is thrown by this line var grid = (List<CarRentalAddress>)Cache["xml"]; totalrows = grid.Count().ToString(); grdAddress.DataSource = grid; grdAddress.DataBind(); } }

View 4 Replies

DataSource Controls :: LINQ Specified Cast Is Not Valid?

Jun 29, 2010

just needing a 2nd set of eyes looking at this to make sure the error isn't something else other than my LINQ code here. Here's the function class itself:


For some reason it's flagging the 2nd line in the GetJacketByPolicyID function saying the specified cast is not valid. So I'm guessing it's something I'm doing wrong. I'm sure the tblPolicy/tblPolicies class works right since I can create a new instance of a tblPolicy and set a few variables by hand and return it, so that's not it. I've also checked the datarow I'm fetching and there's no null values in the record, so that shouldn't be it either.

View 2 Replies

DataSource Controls :: Using Cast And Sum On VarChar Column?

Sep 29, 2010

I have a little problem developing a SQL Select Statement on a column that is formatted pretty badly. Firstly, the Database has already been created and filled with Data in a Test Environment, I'm not sure if the format is the same or has been updated in Production but since I'm only able to work with the Test Environment right now I'm stuck with using what I have. The Column in one Table shows a Snapshot of a clients account which is set to VarChar(50) but the actual data in the column is formatted like a money format (with a $ and decimal point so for example "$5,000.00" would be an entry in one Row).

What I'm trying to do is a create a WebService that will be used in a iPhone Application and one of the Methods needs to just give a quick display of the total value of all Clients with each specific company but I can't perform a SUM function on a VarChar column and I've tried to CAST and CONVERT the column into money, int, decimal and just about every format I can think of but I keep getting an error stating that I convert the data type varchar to which ever one I'm trying. I think it has something to do with the $ already listed in the Column, so I wanted to know what I could do to either remove the $ sign (like a Trim option) or if there is a better way of doing this that I can't think of. I know the best option would be to convert the column to the appropriate format but as I said, this was a previously designed system and I'm not sure if the Production area is the same (most likely not).

Here's what I've tried so far:


View 5 Replies

DataSource Controls :: Split / Cast A String In Sql For Comparison?

Feb 8, 2010

comparing integer values which are actually in string (varchar(9)) right now...I'm trying to do the following in a stored procedure..

SET @MinProjectYear = SELECT ProjYear FROM P_A WHERE ID = @ID
SET @MaxProjectYear = SELECT ProjYear FROM P_A WHERE UserId = @UserID AND...
IF EXISTS(SELECT 1 FROM P_A WHERE MinProjectYear <= MaxProjectYear)
return true

The MinProjectYear and MaxProjectYear are varchar(9) values stored as "2007-2008", "2009-2010", etc.
How do I split and compare the years?? i.e. check if 2007-2008 <= 2009-2010 ??

View 6 Replies

DataSource Controls :: Session Variable Causes Cast Error?

Jun 23, 2010

I get a casting error on line #8 below which reads "db.UserID = Session("UserID")". What would be the correct way to cast this? The datatype of the DB field is GUID.


View 4 Replies

DataSource Controls :: Object Can Not Be Cast From Dbnull To The Other Types?

May 24, 2010

I have a webpage, i have a usercontrol in it , its name ispersonal1, i have tow Radiobutton in this usercontrol, the id of one of them ismale and the other one is female, it is obviously that each time we fill one of these radiobuttons and the other one will be null,in my database the type of these fields are bit , and they have allow null, i defined a property for my usercontrol like this:

public bool male


View 2 Replies

DataSource Controls :: Unable To Cast Object Of Type 'System.Data.Linq.DataQuery?

Mar 31, 2010

I wanted to delete the record from data but I receive this error "Unable to cast object of type 'System.Data.Linq.DataQuery`1[training_eval.Course]' to type 'training_eval.Course'.

Dim eval_sure = From ev In db.Evaluates Where ev.course_id = indexcourse Select ev.course_id
Dim del_course = From c In db.Courses Where c.Course_id = indexcourse

View 4 Replies

DataSource Controls :: How To Use Cursor In Recursive Sql Function (scalar-value Function)

Apr 25, 2010

how can i use cursor in this function ?

ALTER FUNCTION [dbo].[GetCatIDChilds]


@CatID [code].....

View 1 Replies

C# - LinqTOsql Returning A "specified Cast Not Valid" Exception At Runtime?

Nov 16, 2010

I have two linqTOsql entities that has a parent and child relationship, one to many. I'm running into an issue that when I retrieve the parent record, I am unable to loop through the related records in the child table.This code fails:

public string test()
string output;


View 1 Replies

C# - What Else Can Cause 'Padding Is Invalid And Cannot Be Removed" Exception With WebResource.axd

May 7, 2010

Recently, a couple of my applications have started throwing exceptions with the message Padding is invalid and cannot be removed intermitently

My applications already have a machineKey specified in the web.config as suggested in this thread

The applications are deployed to a single Windows 2003 server running IIS6.

View 1 Replies

The Handle Is Invalid. (Exception From HRESULT: 0x80070006 (E_HANDLE)) / What Is Solution

Dec 6, 2010

My web application some times gives error 'The handle is invalid. (Exception from HRESULT: 0x80070006 (E_HANDLE))' on server. I never comes on production server. Then I just upload the bin folder again on server and it starts running fine. I don't know what is the actual reason behind this.

Some experts suggested Min pool size =1, I applied that but no luck.

I have attached error image.

View 9 Replies

Name Of Exception Thrown At Invalid Login During Lists.asmx In SharePoint?

Jan 18, 2011

what is the name of exception class which is being thrown when a client calls a web service with an invalid credentials in SharePoint.

View 1 Replies

DataSource Controls :: Invalid Value For Key AttachDbFilename

Jul 10, 2010

I am making a project on vb .net. I am using the connection string , "Data Source=.SQLEXPRESS;AttachDbFilename=""|DataDirectoy|Database.mdf"";Integrated Security=True;User Instance=True". My login page was running untill yesterday but now its giving the error "Invalid value for key AttachDbFilename"

View 1 Replies

DataSource Controls :: Invalid Directory In Sql 2005

Jan 13, 2010

When i open a table in Sql 2005 i get an error Invalid directory

View 1 Replies

DataSource Controls :: Invalid Object Name 'dbo.pages_Allowed'

May 18, 2010

I have created my function as follows

USE [fedach]
/****** Object: UserDefinedFunction [dbo].[pages_Allowed] Script Date: 05/18/2010 14:14:34 ******/
CREATE FUNCTION [dbo].[pages_Allowed] (@username varchar(35))
RETURNS varchar(30) AS BEGIN -- Declare the return variable here DECLARE @pages varchar(30)
DECLARE @PRvalidate tinyint,@PRdownload tinyint,@PRupload tinyint, @Pages as varchar(35)
select @PRvalidate=Rvalidate,@PRdownload=Rdownload,@PRupload=Rupload from tblPermittedpages where Username=@username;
select @Pages = case
when @PRvalidate=1 and @PRdownload=1 and @PRupload=1
then 'Admin'
when @PRvalidate=1 and @PRdownload=0 and @PRupload=0
then 'Validate Only'
when @PRvalidate=0 and @PRdownload=1 and @PRupload=0
then 'Download Only'
when @PRvalidate=1 and @PRdownload=0 and @PRupload=0
then 'Validate and Download' End;
return @pages

But when i am running the function i am getting the error as Invalid object name 'dbo.pages_Allowed'. can any one tell why?

View 7 Replies

DataSource Controls :: Invalid Column Name 'ContractDocumentType'

Jun 3, 2010

I have two drop down lists and a upload control. One dropdown allows my user to select a valid contract number, and the second dropdown is populated from a table that has 5 contract document types and id's.

after i use the dropdowns to select the information i want and select the file i want to upload based on that information, I press my upload button and get " Invalid column name 'ContractDocumentType'."

It is very possible that I have extra code in here that is not necessary as I have fixed several issues before this one, such as a convert varchar to int error.

What Contract Number Are These Documents Related To?

<asp:DropDownList ID="lstContractNumber" runat="server"
DataSourceID="dsdContractNumbers" DataTextField="ContractNumber"
<asp:SqlDataSource ID="dsdContractNumbers" runat="server"

My code-behind (I edited out some stuff that is probably not needed here):




View 6 Replies

User Controls :: Cancel CreateUserWizard Step If Captcha Code Is Invalid

Jul 23, 2012

Despite inputting the wrong answer for the captcha control, it did not display an error message.. 

  protected void CreateUserWizard1_CreatedUser(object sender, EventArgs e)
MSCaptcha.CaptchaControl Captcha1 = (CreateUserWizardStep1.ContentTemplateContainer.FindControl("Captcha1") as MSCaptcha.CaptchaControl);
TextBox txtCaptcha = (TextBox)CreateUserWizardStep1.ContentTemplateContainer.FindControl("txtCaptcha");

[Code] .....

View 1 Replies

DataSource Controls :: How To Cast Concrete Type Created In LINQ Query To The Corresponding Interface Type

May 3, 2010

I have an Interface that has its concrete class defined via a factory. Because of this I found no way to use the Interface tpye directly in my LINQ quesry so I had to use the concrete class types to creat a generic list. The LINQ query works but after calling.ToList() on the LINQ query result I get a List(of MyConcreteClass), but I need a List(of IMyConcreteClass). I have tried everything I can find: .Cast, Ctype, implicit casting, etc. but I always get back one of the (2) messages (depending on if I attempt to cast)message:

"Unable to cast object of type 'System.Collections.Generic.List`1[MyConcreteClass]' to type 'System.Collections.Generic.IEnumerable`1[IMyConcreteClass]'."
"Unable to cast object of type '<CastIterator>d__aa`1[IMyConcreteClass]' to type 'System.Collections.Generic.List`1[MyConcreteClass]'."

Here is the sample code:


View 2 Replies

Copyrights 2005-15, All rights reserved