.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

Failed to convert parameter message

Posted By:      Posted Date: October 16, 2010    Points: 0   Category :ASP.Net

I'm trying to pass values in a SessionState from one page to another and then post them to a SQL database. When I click on the submit button on my submit page, I get this error:

Failed to convert parameter value from a String to a DateTime.

Here is my submit page:

Imports System.Data.SqlClient
Imports System.Data

Partial Class Default2
    Inherits System.Web.UI.Page
    Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
        Dim opnumber As String = CType(Session.Item("opnumber"), String)
        Dim exceptiondate As DateTime = CType(Session.Item("exceptiondate"), DateTime)
        Dim stime As DateTime = CType(Session.Item("starttime"), DateTime)
        Dim etime As DateTime = CType(Session.Item("endtime"), DateTime)
        Dim hours As String = CType(Session.Item("hours"), String)
        Dim minutes As String = CType(Session.Item("minutes"), String)
        Dim exceptioncode As String = CType(Session.Item("exceptioncode"), String)
        Dim submittedby As String = CType(Session.Item("submittedby"), String)
        opnumLabel.Text = opnumber
        exceptdateLabel.Text = exceptiondate
        starttimeLabel.Text = stime
        endtimeLabel.Text = etim

View Complete Post

More Related Resource Links

Failed to convert parameter value from a String to a Guid.


I am trying to get the UserRole from the logged in user and send it to the database table my code is:

SqlParameter FamilyFriendsOther = new SqlParameter("@Role", SqlDbType.UniqueIdentifier);
        string [] roles = System.Web.Security.Roles.GetRolesForUser();
        if (roles.Length > 0)
            FamilyFriendsOther.Value = roles[0];

Failed To Convert Parameter Value From A String To A Int32

 This is my stored procedure: PROCEDURE[dbo].[uspEXPENDITURE_DETAILS] ( @ExpDetailsID int=0 output, @ExpDet_ExpID int, @ExpDet_Municipality_ID nvarchar(50), @ExpDetGeneralFund money, @ExpDetSpecialRevenue money, @ExpDetCapitalProjects money, @ExpDetTotal money, @Exp_Reporting_Year varchar(10), @ExpComments varchar(max), @Contact_ID int ) AS BEGIN  -- SET NOCOUNT ON added to prevent extra result sets from  -- interfering with SELECT statements.  SET NOCOUNT ON; deletefrom [dbo].[TBL_EXPENDITURE_DETAILS] where ExpDet_ExpID=@ExpDet_ExpID and ExpDet_Municipality_ID=@ExpDet_Municipality_ID and Exp_Reporting_Year=@Exp_Reporting_Year If@ExpDetailsID >= 0 Begin INSERT     INTO [dbo].[TBL_EXPENDITURE_DETAILS] ([ExpDet_ExpID] ,[ExpDet_Municipality_ID] ,[ExpDetGeneralFund] ,[ExpDetSpecialRevenue] ,[ExpDetCapitalProjects] ,[ExpDetTotal] ,[Exp_Reporting_Year] ,[ExpComments] ,[ExpDetCreatedBy] ,[ExpDetCreateDate]) VALUES  (@ExpDet_ExpID , @ExpDet_Municipality_ID , @ExpDetGeneralFund, @ExpDetSpecialRevenue , @ExpDetCapitalProjects, @ExpDetTotal, @Exp_Reporting_Year, @ExpComments, @Contact_ID, GetDate () )    SET @ExpDetailsID = SCOPE_IDENTITY()  return @ExpDetailsID end   Public Sub CreateExpenseDetails() Dim item As GridViewRow Dim txtExpGenFund, txtExpD

failed to convert parameter value from a string to a int32

I am not sure where my app is failing but most probably this is where it is failing.. I think lblExpID.Text is the culprit. Here's the relvant part of my code: Dim lblExpID As Label For Each item In LSGrid.Rows lblExpID = item.FindControl("lblID") If txtExpGenFund.Text <> "" Then sqlArray(i) = ExpDetailsID & "," & (lblExpID.Text) & "," & MunID & "," & _ Val(txtExpGenFund.Text) & "," & Val(txtExpDetSpecialRevenue.Text) & "," & _ Val(txtExpDetCapitalProjects.Text) & "," & expTotal & "," & reportingYear & "," & "Test Comments" & "," & UserID End If Can u help me identify why i am getting this error looking at the sp below: PROCEDURE [dbo].[uspEXPENDITURE_DETAILS] ( @ExpDetailsID int=0 output, @ExpDet_ExpID int, @ExpDet_Municipality_ID nvarchar(50), @ExpDetGeneralFund money, @ExpDetSpecialRevenue money, @ExpDetCapitalProjects money, @ExpDetTotal money, @Exp_Reporting_Year varchar(10), @ExpComments varchar(max), @Contact_ID int ) AS BEGIN -- SET NOCOUNT ON added to prevent extra result sets from -- interfering with SELECT statements. SET NOCOUNT ON; delete from [dbo].[TBL_EXPENDITURE_DETAILS] where ExpDet_ExpID=@ExpDet_ExpID and ExpDet_Municipality_ID=@ExpDet_Municipality_ID and Ex

Crystal Report vs 2003 convert to vs 2008 parameter problem


Hi friend,

I have a project develop with Visual Studio 2003, when i convert the project to Visual Studio 2005 is work well. But when i convert to Visual Studio 2008, the crystal report when have pass parameter will prompt the parameter field to re-type then show the report.

But in this converted project i create a new report and pass the parameter is ok. That means i wan re-do all report @.@??

Does someone can help me solve this problem??

Thank you

MessageSecurityException "Identity check failed for outgoing message" when using custom endpointaddr

Hi! I am currently developing a WCF service which will use ASP.NET Membership and RoleProvider as authentication/authorization. I followed the description in on this page http://msdn.microsoft.com/en-us/library/ff647294.aspx to do this, and everything works as expected when I try add a reference to my development service and uses that without any interaction. But, I want to be able to override the enpoint address in code since the server may be placed on other servers, but when I do this in my code (with the same enpointAddress stated in the client wcf file for testing purpose) I get a MessageSecurityException with this information: "Identity check failed for outgoing message. The expected DNS identity of the remote endpoint was 'localhost' but the remote endpoint provided DNS claim 'MyCert'. If this is a legitimate remote endpoint, you can fix the problem by explicitly specifying DNS identity 'MyCert' as the Identity property of EndpointAddress when creating channel proxy." I have search the net for information about this, and found that the only thing I had to do was to add a <dns value="MyCert" /> to my client wcf configuration, and everything should work. But it doesn't, I still get the same error. My server behavior configuration looks like this: <serviceCredentials> <serviceCertificate findValue="CN=MyCert" />

Message: "Microsoft .NET Framework 3.5 Installation Has Failed"

On a Windows 2003 R2 x64 server, I have been unable to install SQL Server 2008 Enterprise Edition x64. When running setup.exe, I almost instantaneously receive the following Microsoft SQL Server Setup error:"Microsoft .NET Framework 3.5 installation has failed.SQL Server 2008 Setup requires .NET Framework to be installed."What does not make sense is that I successfully downloaded .NET Framework 3.5 from the Microsoft download site (published 8/11/2008) prior to the SQL Server 2008 installation attempt.http://www.microsoft.com/downloads/details.aspx?familyid=ab99342f-5d1a-413d-8319-81da479ab0d7&displaylang=enI do need to note that a few nights ago, prior to downloading the framework (3.5 SP1), I ran the SQL Server 2008 setup executable. I was prompted that in order to install SQL Server 2008, the setup program needed to first install .NET 3.5 SP1 and Windows Installer 4.5. I let the .NET 3.5 SP1 install run for about 1.5 to 2 hours and cancelled (now I wish I had just let it go).It is my understanding (correct me if I am wrong) that the SQL Server 2008 setup program initially checks for any pre-RTM versions of .NET 3.5 SP1 Framework. If one is found, it is then supposed to guide the user through both the installation of the .NET 3.5 SP1 Framework and Windows Installer 4.5. I have removed .NET 3.5 SP1 Framework (Add/Remove programs) and rebooted. However, upon runni

Error Message: The attempt to connect to the report server failed. Check your connection informatio

I have a web page that contains a ReportViewer control.  I am trying to display a report, which is an .rdl file located on the SSRS server, in this ReportViewer control.  I have set the ReportPath and ReportServerUrl correctly.  I am getting an error message. Am I suppose to use an .rdlc file rather than a .rdl file?  Does the web server configuration need to use a certain account?  I am getting the following error message: The attempt to connect to the report server failed. Check your connection information and that the report server is a compatible version. The request failed with HTTP status 404: Not Found.

Media Web Part displays "Media failed to load" message.

I am unable to use the Media web part to play a wmv file.  The wmv file (112 KB) is loaded to an asset libray. When I browse to the library and click on Play, I get "Media failed to load" error message. Please help. Thank you, Reggie    

WCF Exception "Message security verification failed" only with header!

Hi, I've got a WCF service doing Username authentication. I authenticate with AD and authorize using AzMan on AD. I'm hosting the service in IIS 6 and its running in an app pool that runs in a domain account that has read rights on the AD. I have a custom header that goes both ways. Everything works well until I assign the custom header to return. If I never assign the custom header to return everything is ok but if I do assign the custom header to return I get the error:- Message security verification failed.Duplicate attribute found. Both 'u:Id' and 'u:Id' are from the namespace 'http://docs.oasis-open.org/wss/2004/01/oasis-200401-wss-wssecurity-utility-1.0.xsd'. Line 1, position 520. I've got service level message tracing and I can see the secure conversation stuff happening and the messages going across the interface.   If anyone has any ideas I'd be most appreciative.   Thanks,   Andy

.NET 3.5 SP1 failed with the error message - Error code 1603 for this component means Fatal error du

I had Beta version of VS 2008 and I wanted to install .NET 3.5 SP1. Installation led to some serious problems. I tried almost everything to install .NET 3.5SP1 (or VS 2008 SP1), nothing works

* VS 2008 has been uninstalled
* 3.5 uninstalled and cleaned
* 3.0 uninstalled and cleaned
* WF components removed
* document manager components removed

when I try to reinstall 3.5SP1, I keep receiving the following error in dd_dotnetfx35error

[01/11/09,00:23:05] XPSEPSC Installer: [2] Error code 1603 for this component means "Fatal error during installation.
[01/11/09,00:23:06] XPSEPSC Installer: [2] Setup Failed on component XPSEPSC Installer
[01/11/09,00:23:32] WapUI: [2] DepCheck indicates XPSEPSC Installer is not installed.

Then I check the contents of dd_dotnetfx35install for the event error log and found the following
[01/11/09,00:23:05] XPSEPSC Installer: ***ERRORLOG EVENT*** : Error code 1603 for this component means "Fatal error during installation.
[01/11/09,00:23:05] Setup.exe: AddGlobalCustomProperty
[01/11/09,00:23:06] XPSEPSC Installer: ***ERRORLOG EVENT*** : Setup Failed on component XPSEPSC Installer
[01/11/09,00:23:06] Setup.exe: GetGlobalCustomProperty - Property: {BBE1827C-F2FD-4FDA-A6D6-C83B62FFFDCA} - PropertyName: compfailed - Value: 0
[01/11/09,00:23:06] XPSEPSC Installer: CBa

error message on clicking a specific view


Hi there,

Please find below the description of my problem:

When I click on a view(eg. Doc Type/Sub Doc Type in our case), I am shown the error message "<!-- #RENDER FAILED -->". Basically what we do is a migration of data(mostly documents) from Webdocs to Sharepoint. So each Business Unit that we migrate has variable item count as 750, 2500, 13000 and so on. There is no problem with Business Units(BU) having, say less than 2000 items in Doc library, but for BUs more than this item count we get this error msg.Is there a workaround for this?. Also I've tried to limit the no. of items shown and other options but in vain.




Failure Message Object WSS_Content_MyActiveSite failed in event OnBackup




Hey Guys,

I am hoping you can help me with my backup issues.  I am currently trying to run a backup and I keep getting the same error message (whether it is a full, farm, or differential).


For this example I am just trying to backup my active site and i get the following error message.


Object WSS_Content_MyActiveSite failed in event OnBackup. For more information, see the spbackup.log or sprestore.log file located in the backup directory


when I check the log, i get the following information:


10/6/2010 1:36:35 PM] Verbose: Starting OnBackup event.
[10/6/2010 1:36:35 PM] Verbose: Starting object: SharePoint - My Active Site.
[10/6/2010 1:36:36 PM] Verbose: Starting object: WSS_Content_MyActiveSite.
[10/6/2010 1:36:36 PM] Progress: [SharePoint - My Active Site] 50 percent complete.
[10/6/2010 1:36:36 PM] Verbose: Starting object: job-workflow-failover.
[10/6/2010 1:36:38 PM] Progress: [job-workflow-failover] 50 percent complete.
[10/6/2010 1:36:38 PM] Verbose: [WSS_Content_MyActiveSite] SQL Server Connection String: Data Source=SV03MIS017\SHP1;Initial Catalog=WSS_Content_MyActiveSite;Integrated Security=True;Enlist=False;Connect Timeout=15.
[10/6/2010 1:36:38 PM] Verbose: Starting object: ExpirationProcessing.

OCIEnvCreate failed with return code -1 but error message text was not available.



We have a requirement to connect to oracle from ASP.NET and we installed ODAC(ODAC1110621) components  on the server but still we are getting the following error while opening the connection. Please find the details below:-

OCIEnvCreate failed with return code -1 but error message text was not available.

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.Exception: OCIEnvCreate failed with return code -1 but error message text was not available.

Source Error:

Line 16:     {
Line 17:         OracleConnection con = new OracleConnection(ConfigurationManager.ConnectionStrings["HRDBA"].ConnectionString);
Line 18:         con.Open();
Line 19:         Label1.Text = con.State.ToString();
Line 20:         con.Close();

Source File: \\hs003fs01-02.homebase.com\wfmp\Webpage1.aspx.cs    Line: 18

Stack Trace:

Convert string value to type and pass as type parameter.



In the below code... i am getting all filenames from a directory.  parsing out the directory names & the .vb extension. . . then converting those filesnames to classes.  Every file in the LPCriteria direcotry is its own class with a "Evaluate" function.

The problem comes in here:

Dim boolFlagged As Boolean = CType(MyInstance, objType).Evalua

Because the "objType" comes up as "type 'objType' is not defined".   the parameter requested is "Object as Type".  But i dont know the type, as it is really the name of the file...       any ideas how i get this parameter passed in?   Thanks! :)

Dim strPath As String = System.AppDomain.CurrentDomain.BaseDirectory()
Dim files As String() = System.IO.Directory. _
     GetFiles(strPath & "App_Code\GeneralClasses\LPCriteria\", "*")


WCF client fails with The message received was unexpected or badly formatted and Decrypt failed with


I have written a console mode WCF client that contacts an Apache based web service that uses OpenSSL  0.9.8 tls or ssl3.
The WCF client uses client certificates on Windows 2008 SP2 x64. The client had been running for months with no problem, and then I started getting the errors below around Nov 8 2010 (below).
I have done my best to include all the details. Please read carefully.
The relevant traces, exceptions, code and config are included in this post.

1.) Fix it.
2.) Find out what 0X80090326 means.
3.) Find out what policies/acl's apply to the situation

The only thing I can be sure of that did not change is the code.

Can anyone point me toward the next step?

- The program executes as a local user (non-domain) that is in the Local Administrators group.
- I can display the server url using IE and Firefox, provided I have the certs installed for personal use.
- The certificates are installed in the LocalMachine store in "TrustedPeople" - NOT the user's location, the machine location. The local user finds the proper key, as the trace below will show.

What I have googled for:
- 0X80090326
- Decrypt failed with error 0X800

Restore Job has been failed with error message as "Skipped log backup file. Secondary DB"


We have already configured log shipping on server. But now restore job failed with error message as "Skipped log backup file. Secondary DB"

Kindly provide resolution steps for same.

Gmail internal chat like message box

This article provides you with the multi-functional message box window through which the usability of the web-site or any web application increases.

.Configurable MessageBox window with AJAX Support
.can set maximum number of message boxes to be visible
.can define the auto reload time, for single message, for all messages or no reload
.can create messages through a single function call
.can define auto hide time for each messages
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend