Results 1 to 8 of 8

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. #1
    Banned
    Join Date: Nov:2008
    Location:
    Posts: 64

    Unhappy C# Access Database ()

    : Specified cast is not valid.
    , .
    , .
    string sql;
    sql = "SELECT U.USER_ID, U.USER_NAME, U.RIGHTS AS USER_RIGHTS, IIF(G.RIGHTS, 1, 0) AS GROUP_RIGHTS";
    sql = sql + " FROM ((USERS U LEFT JOIN GROUP_USERS GU ON U.USER_ID = GU.USER_ID) LEFT JOIN";
    sql = sql + " GROUPS G ON G.GROUP_ID = GU.GROUP_ID) WHERE (U.USER_NAME = @USER_NAME) AND (U.[PASSWORD] = @PASSWORD)";
    OleDbCommand aCommand = new OleDbCommand(sql, aConnection);
    aConnection.Open();

    OleDbParameter parametar = aCommand.CreateParameter();
    parametar.ParameterName = "USER_NAME";
    parametar.Value = username;
    aCommand.Parameters.Add(parametar);
    parametar = aCommand.CreateParameter();
    parametar.ParameterName = "PASSWORD";
    parametar.Value = password;
    aCommand.Parameters.Add(parametar);
    OleDbDataReader aReader = aCommand.ExecuteReader(CommandBehavior.C loseConnection);
    while (aReader.Read())
    {
    if (userData_1 == null)
    {
    userData_1 = new UserData((int)aReader["USER_ID"], aReader["USER_NAME"].ToString(), (long)aReader["USER_RIGHTS"]);
    }
    if (aReader.IsDBNull(aReader.GetOrdinal("GR OUP_RIGHTS")))
    {
    userData_1.ApplyRights((long)aReader["GROUP_RIGHTS"]);
    }
    }

  2. #2
    Registered User
    Join Date: Oct:2003
    Location:
    Posts: 4,317
    , .

    - ? USER_NAME , [] : , "Gets the value of a column in its native format". ToString().
    Last edited by bsb; 3rd December 2008 at 16:41.

  3. #3
    Executor Lan's Avatar
    Join Date: Nov:2005
    Location:
    Posts: 3,304
    3- UserData string?
    I mourn thee by dusk | I mourn thee by dawn
    Crave for thy gloss | to seek the silent glades beyond

  4. #4
    Banned
    Join Date: Nov:2008
    Location:
    Posts: 64
    UserData(int,string,long)
    ToString()
    The best overloaded method match for 'VideoStore.UserData.UserData(int, string, long)' has some invalid arguments

    Argument '2': cannot convert from 'object' to 'string'

  5. #5
    Defender Kaspirtov's Avatar
    Join Date: Jun:2006
    Location: Sf
    Posts: 7,414
    Quote Originally Posted by Thunder777 View Post
    UserData(int,string,long)
    ToString()
    The best overloaded method match for 'VideoStore.UserData.UserData(int, string, long)' has some invalid arguments

    Argument '2': cannot convert from 'object' to 'string'
    , :

    userData_1 = new UserData((int)aReader["USER_ID"], (string)aReader["USER_NAME"], (long)aReader["USER_RIGHTS"]);
    " , , , , ."

  6. #6
    Banned
    Join Date: Nov:2008
    Location:
    Posts: 64
    .
    UserData .
    username password .
    public static class Inditification
    {
    public static void Authorization(string username, string password)
    {

  7. #7
    Registered User 's Avatar
    Join Date: Feb:2006
    Location:
    Posts: 653
    , OleDbType btw parameter. :
    Code:
    parametar.ParameterName = "USER_NAME";
    parametar.OleDbType = OleDbType.Int32;
    parametar.Value = username;
    aCommand.Parameters.Add(parametar);
    parametar = aCommand.CreateParameter();
    parametar.ParameterName = "PASSWORD";
    parametar.OleDbType = OleDbType.WChar;
    parametar.Value = password;
    aCommand.Parameters.Add(parametar);

  8. #8
    Registered User
    Join Date: Apr:2004
    Location: EU
    Posts: 141
    :
    (int)aReader["USER_ID"]

    (long)aReader["USER_RIGHTS"]

    .
    user_id user_rights

    :

    int ordinal = aReader.GetOrdinal("USER_ID");
    aReader.GetInt32(ordinal); GetInt64() .
    Last edited by zstoev; 4th December 2008 at 09:36.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Copyright © 1999-2011 . .
iskamPC.com | mobility.BG | Bloody's Techblog | | 3D Vision Blog |