Specified cast is not valid

[Digiplex]

Hi all, I'm working in C# and the following works on my local box (vista) but when I load it to the server and test I get an Invalid Cast Exception error. (I'm new to C# and yeah I know I'm late to the ballgame) Please help. The stack trace indicates the error is here ("SetUserData("LakinPortal", Login1.UserName, Login1.Password);") see listing below.

using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using TheMembershipProvider;
 
public partial class _Default : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
    }
 
    protected void OnLoggingIn(object sender, EventArgs e)
    {
        //Set User rights to db
        SetUserData("LakinPortal", Login1.UserName, Login1.Password);
 
    }
 
    public void SetUserData(string AppName, string username, string password)
    {
        DataTable ds = new DataTable();
        string strPwd;
 
        try
        {
            TheMembershipProvider.TheMembershipProvider Mem = new TheMembershipProvider.TheMembershipProvider();
 
            ds = Mem.GetUserSecParams(username, password);
 
...
 

[beebob]

I am also a beginner in C#, but I will try to help you.. :-)

First of all, I want to know something in your code:
1. Are you sure that Login1.UserName and Login1.Password are really a string?
2. What is Login1?
3. Have you try to use something like this:

...
SetUserData("LakinPortal", <write_your_login_name_here>, <write_your_login_password_here>);
...
 

I mean, put the real login name and login password in that part of your code, not by getting the string from other part / parameter. Try this, and if you get the same error, it means the problem is not at SetUserData.

Hope it can help.


Regards,
Novan Ananda

Hi all, I'm working in C# and the following works on my local box (vista) but when I load it to the server and test I get an Invalid Cast Exception error. (I'm new to C# and yeah I know I'm late to the ballgame) Please help. The stack trace indicates the error is here ("SetUserData("LakinPortal", Login1.UserName, Login1.Password);") see listing below.


using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using TheMembershipProvider;

public partial class _Default : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
}

protected void OnLoggingIn(object sender, EventArgs e)
{
//Set User rights to db
SetUserData("LakinPortal", Login1.UserName, Login1.Password);

}

public void SetUserData(string AppName, string username, string password)
{
DataTable ds = new DataTable();
string strPwd;

try
{
TheMembershipProvider.TheMembershipProvider Mem = new TheMembershipProvider.TheMembershipProvider();

ds = Mem.GetUserSecParams(username, password);

...

[Digiplex]

Thanks for the suggestion, but it didn't work. To be more precise on my development environment it works, just as the original code does but on the production box I get the Specified cast is not valid error. I’m using ASP 2.0 on both. My dev box is using Visual Studio 2005. This is perplexing. Hey but keep the ideas coming thanks.

I’ve change the code a little to pass ref’s to see if that makes a diff, but noooo. Here is the slightly new code:

using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using TheMembershipProvider;
 
public partial class _Default : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
    }
 
    protected void OnLoggingIn(object sender, EventArgs e)
    {
        //Set User rights to db
        //SetUserData("LakinPortal", Login1.UserName, Login1.Password);
        SetUserData("LakinPortal", "joe", "joepw"); //just a test
 
    }
 
    public void SetUserData(string AppName, string username, string password)
    {
        DataTable ds = null;
        string strPwd;
        int Roweffected = 0;
 
        try
        {
            TheMembershipProvider.TheMembershipProvider Mem = new TheMembershipProvider.TheMembershipProvider();
 
            Roweffected = Mem.GetUserSecParams(username, password, ref ds);
 
            if (Roweffected > 0)
            {…
 

And here is a piece of the code from TheMembershipProvider dll which is custom:

using System;
using System.Reflection;
using System.Web;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web.Security;
using System.IO;
using System.Security.Cryptography;
using System.Collections.Specialized;
using System.Data.SqlClient;
using TheDatabase.Utilities.Database;
 
namespace TheMembershipProvider
{
    public class TheMembershipProvider: MembershipProvider
    {
. . .
 
        public int GetUserSecParams(string username, string password, ref DataTable d)
        {
            DBConString = GetConnectionString();
 
            try
            {
                SqlParameter[] p = new SqlParameter[2];
 
                SqlParameter a = new SqlParameter("@userid", SqlDbType.VarChar);
                a.Value = username;
                a.Direction = System.Data.ParameterDirection.Input;
                p[0] = a;
 
                SqlParameter b = new SqlParameter("@password", SqlDbType.VarChar);
                b.Value = password;
                b.Direction = System.Data.ParameterDirection.Input;
                p[1] = b;
 
 
                TheDatabase.Utilities.Database.TheDatabase LakinDB = new TheDatabase.Utilities.Database.TheDatabase(DBConString);
                int RowsAffected = 0;
                RowsAffected = TheDB.ExecuteQueryStoredProcedure("getdata", ref p, ref d);
 
                return RowsAffected;
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }
. . .
 

[Plater]

Vista uses completely different styles for verification/authorization.

I would guess something you are using is not the same object on other OSs.

Where you able to get a more percise location from the stacktrace when you used literal string to test the SetUser()?

[Digiplex]

Vista uses completely different styles for verification/authorization.

I would guess something you are using is not the same object on other OSs.

Where you able to get a more percise location from the stacktrace when you used literal string to test the SetUser()?

No here is the stack trace:

Server Error in '/' 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.]
_Default.SetUserData(String AppName, String username, String password) +1194
_Default.OnLoggingIn(Object sender, EventArgs e) +23
System.Web.UI.WebControls.Login.OnLoggingIn(LoginC ancelEventArgs e) +105
System.Web.UI.WebControls.Login.AttemptLogin() +67
System.Web.UI.WebControls.Login.OnBubbleEvent(Obje ct source, EventArgs e) +99
System.Web.UI.Control.RaiseBubbleEvent(Object source, EventArgs args) +35
System.Web.UI.WebControls.Button.OnCommand(Command EventArgs e) +115
System.Web.UI.WebControls.Button.RaisePostBackEven t(String eventArgument) +163
System.Web.UI.WebControls.Button.System.Web.UI.IPo stBackEventHandler.RaisePostBackEvent(String eventArgument) +7
System.Web.UI.Page.RaisePostBackEvent(IPostBackEve ntHandler sourceControl, String eventArgument) +11
System.Web.UI.Page.RaisePostBackEvent(NameValueCol lection postData) +33
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1746




--------------------------------------------------------------------------------
Version Information: Microsoft .NET Framework Version:2.0.50727.1433; ASP.NET Version:2.0.50727.1433

[Plater]

That is very strange.
Are you able to run a debug session on the computer that it fails on at all?

[Digiplex]

Thanks Plater and Beebob. I figured out the problem, it's in the piece of code I didn't give you. Or, rather the database. Someone else is handling the database portion and stored procedures. For me this is a black box they are suppose to tell me the output types. Well, I'm getting incomplete info on the types which is causing my cast error. Sorry about that. Thanks again.

E.