insert a database value to a string array - not working

Question

Cheers,

Im trying to insert a database value to my string array.

for some reason, it says :

"Object reference not set to an instance of an object."

This is my code :

if (IsPostBack)
{
    if (RadioWords.Checked == true)
    {
        con = new SqlConnection("Data Source=MICROSOF-58B8A5\\SQL_SERVER_R2;Initial Catalog=Daniel;Integrated Security=True");
        con.Open();

        string SqlCount = "SELECT COUNT(*) FROM WordGame";

        SqlCommand command = new SqlCommand(SqlCount, con);

        //Sets an array of the size of the database.
        int count = (Int32)command.ExecuteScalar();
        arrOfWords = new string[count];

        //Initialize the words in the array.
        for (int i = 0; i < arrOfWords.Length; i++)
        {
            int GetRandomNumber =  rnd.Next(1, arrOfWords.Length);

            string Sqlinsert = "SELECT Word FROM WordGame WHERE ID='"+GetRandomNumber+"'";

            SqlCommand commandToRandom = new SqlCommand(Sqlinsert, con);

            arrOfWords[i] = commandToRandom.ExecuteScalar().ToString();
        }
    }

and its refering to this line :

int GetRandomNumber =  rnd.Next(1, arrOfWords.Length);

Thanks for the helpers!

You should absolutely properly dispose the connection and command objects (and if you plan on using one, the reader too). In a small-scale test this will seem to work, but you're going to run out of resources (connections) very quickly on a server. — Lucero
– Lucero, Commented Jan 1, 2012 at 17:06

rene · Accepted Answer · 2012-01-01 16:59:47Z

3

rnd is null , add a line

rnd = new Random();

at the start of your event

answered Jan 1, 2012 at 16:59

rene

42.6k78 gold badges122 silver badges166 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Roman C · Accepted Answer · 2016-03-06 11:49:43Z

1

rnd = new Random();

Instantiate rnd as above. You're using a null object that causes the exception in your question to be thrown.

edited Mar 6, 2016 at 11:49

Roman C

1

answered Jan 1, 2012 at 17:01

Lion

19.1k22 gold badges83 silver badges111 bronze badges

Collectives™ on Stack Overflow

insert a database value to a string array - not working

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related