[Help] Impulse Source Nobility Error.

[killersub]

Hey guys I'm finally back and staying.

I've decided to learn the ropes of coding step by step so I took out a fresh copy of the impulse source and began coding on it(just recently). I coded nobility(parts from another reference), but the MySqlReader is giving me problems while I load up the console.

These are my variables at the top:

private DataSet _dataset;
        private DataRow _datarow;
        private int _row;
        const string Table = "table";

I fixed the NullException error for the Void Read() by replacing it with this:

public bool Read()
        {
            if (_dataset != null && _dataset.Tables[Table].Rows.Count > _row)
            {
                _datarow = _dataset.Tables[Table].Rows[_row];
                _row++;
                return true;
            }
            _row++;
            return false;
        }

don't know if it was a useful change but it worked(I guess).

I get an error now saying:

Object Reference not set to an instance of an Object.

Line 24 NobilityTable.cs is this:

reader.Close();

which is part of this:

public static void Load()
        {
            MySqlCommand cmd = new MySqlCommand(MySqlCommandType.SELECT).Select("nobility");
            MySqlReader reader = new MySqlReader(cmd);
            while (reader.Read())
            {
                Game.ConquerStructures.NobilityInformation nobilityinfo = new Conquer_Online_Server.Game.ConquerStructures.NobilityInformation();
                nobilityinfo.EntityUID = reader.ReadUInt32("EntityUID");
                nobilityinfo.Name = reader.ReadString("EntityName");
                nobilityinfo.Donation = reader.ReadUInt64("Donation");
                nobilityinfo.Gender = reader.ReadByte("Gender");
                nobilityinfo.Mesh = reader.ReadUInt32("Mesh");
                Game.ConquerStructures.Nobility.Board.Add(nobilityinfo.EntityUID, nobilityinfo);
            }
            reader.Close();
            Game.ConquerStructures.Nobility.Sort(0);
            Console.WriteLine("Nobility information loaded.");
        }

And this is the Void Close():

public void Close()
        {
            _dataset.Clear();
        }

From there on I'm a little stuck.

I would appreciate a little help pointing me in the right direction, sorry for my "newb-ness" but I wanted to know what is causing this and why.

Regards, killersub.

[checker345]

Free Bump!

[.Kinshi]

Looks like _dataset in your Close void is null.

[killersub]

Originally Posted by .Kinshi

Looks like _dataset in your Close void is null.

I did breakpoint it and it told me _dataset was in fact null.

the problem is that when I assign it as a new variable it still tells me it's null.

Example:

private DataSet _dataset = new DataSet();

it still tells me it's null.

Sorry for my low level of understanding but I need a little help as to what the problem is.

[Purple<3]

Welcome back,
Maybe this might help?

Read the comments

Also press this link(everyone):

[Korvacs]

If your learning to code step by step, why are you starting working on someone else's source?

Start fresh and actually learn step by step how to put together a project and over come the challenges you face as you go.

[_DreadNought_]

Originally Posted by Purple<3

Welcome back,
Maybe this might help?

Read the comments

Also press this link(everyone):

You know each thanks you give has a unique securityToken? That link will only work for you.

[killersub]

Originally Posted by Korvacs

If your learning to code step by step, why are you starting working on someone else's source?

Start fresh and actually learn step by step how to put together a project and over come the challenges you face as you go.

Because I simply can not put myself to that test at the moment.

My IRL problems and duties are too much of a hassle for me to actually concentrate on C# "step by step"(what I meant by that was to start off with a fresh source that is feature-less(or so to speak) and work my way up slowly).

[Purple<3]

Originally Posted by _DreadNought_

You know each thanks you give has a unique securityToken? That link will only work for you.

ik