MySQL Read Problem

[-Fáng-]

Hey Everyone!

I can't really figure out what's wrong with this code:

public static bool CharExists(string Name)
        {
            bool exists = false;
            MySqlCommand cmd = new MySqlCommand(MySqlCommandType.SELECT);
            cmd.Select("cq_user").Where("name", Name);
            MySqlReader r = new MySqlReader(cmd);
           [COLOR="Red"] if (r.Read())[/COLOR] [COLOR="SeaGreen"]// Line 79[/COLOR]
            {
                if (r.ReadInt32("id") > 0)
                    exists = true;
            }
            return exists;
        }

Basically, this is used in the creation of a new character.
This is how it looks from the database:


This is the error in the console:


Attempting to figure out what's wrong:


Any suggestions?
I am using MySqlHandler.dll

[.Lolcat]

when i know that you must write (r.Read ()) you forgot the space

[-Fáng-]

Originally Posted by .Lolcat

when i know that you must write (r.Read ()) you forgot the space

x_x" ... that's not the problem. lol
That doesn't really make sense... but i tried it anyways. Didn't work still. Line 79.

Thanks for trying =\
I'm going to sleep- I'll respond in the morning.

[dowhatuwant]

You could post the exception it throws in c#?

[Arcо]

Don't you need to convert it to an int when reading it?

[~Falcon]

I've never heard of or used MySqlReader, it's always been MySqlDataReader afaik.

Even then, to initialize you call MySqlCommand.ExecuteReader();

[Korvacs]

Originally Posted by ~Falcon

I've never heard of or used MySqlReader, it's always been MySqlDataReader afaik.

Even then, to initialize you call MySqlCommand.ExecuteReader();

Indeed, you need to use MySqlDataReader:

MySqlDataReader Reader = Com.ExecuteReader();

while (Reader.Read())
{
    //Do Work
}

I would guess that MySqlReader (even though i could find 0 documentation on it on the net, which makes me doubt its existance o.O) would be a class which you would inherit from if you wanted to do really really custom retreives. Although like i said i couldnt find anything even referencing it.

[-Fáng-]

Originally Posted by ☆★Zuper★☆

You could post the exception it throws in c#?

It's posted on the main post in that picture. I boxed the line in red. That's the exception that it prints.

Originally Posted by .Arco

Don't you need to convert it to an int when reading it?

Well, the problem is with line 79, not line 81. If I remove line 81, it comes up with the same error on line 79:

Originally Posted by ~Falcon

I've never heard of or used MySqlReader, it's always been MySqlDataReader afaik.

Even then, to initialize you call MySqlCommand.ExecuteReader();

I looked it up... it's a bit more complicated like that.

Originally Posted by Korvacs

Indeed, you need to use MySqlDataReader:

MySqlDataReader Reader = Com.ExecuteReader();

while (Reader.Read())
{
    //Do Work
}

I would guess that MySqlReader (even though i could find 0 documentation on it on the net, which makes me doubt its existance o.O) would be a class which you would inherit from if you wanted to do really really custom retreives. Although like i said i couldnt find anything even referencing it.

The thing is... this code works perfectly in my other source!
That's what I don't get. I tried it your way but it won't work either. Same Error. I think ImmuneOne wrote a Command using the DataReader. I just found it. Lets see if it works...

Well ****. ImmuneOne's code works perfectly! Maybe it was the database type since it's a binary database. Weird! Well thanks for trying to help everyone. I appreciate it!

Working Code:

public static bool CharExists(string Name)
        {
            bool exists = false;

            MysqlCommand Cmd = new MysqlCommand(CommandType.SELECT);
            Cmd.Select("*", "cq_user");
            Cmd.Done();

            while (Cmd.DataReader.Read())
            {
                if ((Cmd.Read("name") == Name))
                    if (Convert.ToUInt32(Cmd.Read("id")) > 0)
                        exists = true;
            }
            Cmd.End();
            return exists;
        }

[_tao4229_]

Where does it assign the connection the the database?

[bone-you]

Originally Posted by .Lolcat

when i know that you must write (r.Read ()) you forgot the space

Since when do you put spaces between a function and the parenthesis?


Working code:

while (Cmd.DataReader.Read())

Not working code:

if (r.Read()) // Line 79

r = Reader, DataReader = DataReader. Please use the same class before you say they don't work the same.

Different classes do different things and have different ways to handle things. That is why they are not the same class.

[ImmuneOne]

Originally Posted by _tao4229_

Where does it assign the connection the the database?

Everytime the connection accessor gets called within the custom ExecuteCmd() function, the accessor checks if the connection is broken/closed, if so, it get's re-initialized.

[-Fáng-]

Originally Posted by _tao4229_

Where does it assign the connection the the database?

You're completely right! That's not right at all! It's correct but it doesn't actually work! =o lol
This is the code I finally came up with:

int CharID = 0;
            MySqlDataReader Reader;
            MySqlCommand Cmd = new MySqlCommand("SELECT * FROM cq_user WHERE account='" + Account + "'", connection);
            Reader = Cmd.ExecuteReader();
            while (Reader.Read())
            {
                if (Reader.GetString("account") == Account)
                    CharID = Reader.GetInt32("id");
            }
            connection.Close();

            Thread.Sleep(200);

(Opens the connection and sets the connection earlier up in the project) =]

[ImmuneOne]

Originally Posted by -Fáng-

You're completely right! That's not right at all! It's correct but it doesn't actually work! =o lol
This is the code I finally came up with:

int CharID = 0;
            MySqlDataReader Reader;
            MySqlCommand Cmd = new MySqlCommand("SELECT * FROM cq_user WHERE account='" + Account + "'", connection);
            Reader = Cmd.ExecuteReader();
            while (Reader.Read())
            {
                if (Reader.GetString("account") == Account)
                    CharID = Reader.GetInt32("id");
            }
            connection.Close();

            Thread.Sleep(200);

(Opens the connection and sets the connection earlier up in the project) =]

            MysqlCommand Cmd = new MysqlCommand(CommandType.SELECT);//CmdType for the constructor//Adds Select <V> from <T>
            Cmd.Select("*", "cq_task");//Replaces <V> with * and <T> cq_task
            Cmd.Done();//Executes cmd

            while (Cmd.DataReader.Read())//While datareader reads
            {
            }
            Cmd.End(); //Close connection

[-Fáng-]

Originally Posted by ImmuneOne

            MysqlCommand Cmd = new MysqlCommand(CommandType.SELECT);//CmdType for the constructor//Adds Select <V> from <T>
            Cmd.Select("*", "cq_task");//Replaces <V> with * and <T> cq_task
            Cmd.Done();//Executes cmd

            while (Cmd.DataReader.Read())//While datareader reads
            {
            }
            Cmd.End(); //Close connection

I tried that but it doesn't read what I want it to read. The one I'm using is more precise. Thanks for helping out though! =P Your base is great.

[VisualNaff]

Thanks!!