Results 1 to 8 of 8
Thread: C# Access Database ()
Hybrid View
-
3rd December 2008 14:47 #1Banned
Join Date: Nov:2008
Location:
Posts: 64
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"]);
}
}
-
3rd December 2008 16:33 #2Registered 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.
-
3rd December 2008 17:02 #3
3- UserData string?
I mourn thee by dusk | I mourn thee by dawn
Crave for thy gloss | to seek the silent glades beyond
-
3rd December 2008 18:02 #4Banned
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'
-
3rd December 2008 18:55 #5
-
3rd December 2008 20:29 #6Banned
Join Date: Nov:2008
Location:
Posts: 64
.
UserData .
username password .
public static class Inditification
{
public static void Authorization(string username, string password)
{
-
3rd December 2008 20:30 #7
, 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);
-
4th December 2008 09:25 #8Registered 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.




Reply With Quote

Lenovo ThinkPad 15 IdeaPad 15
5th May 2023, 22:16 in