how to increment index value of integer array

Question

I want to store value from datatbase table to array.but when I do,exception"object eferance not set instance of object " through please review my code.

.cod Behinde

   public DataSet showoption1()
    {
        SqlCommand cmd = new SqlCommand("select * from assessmenttest",con);

        SqlDataAdapter adptr = new SqlDataAdapter(cmd);

        DataSet ds = new DataSet();
        adptr.Fill(ds,"test");

        int [] arr=new int[10];
        DataTable table=ds.Tables[0];
        for(int i=0;i<table.Rows.Count;i++  )
        {
test.Agree[i] =Convert.ToInt32(ds.Tables[0].Rows[i]["option1"]);

    }

Business logic layer class code:

public class test{

public static int[] agree;

}

possibly test or test.agree not initialized...but why you using array? — Renatas M.
– Renatas M., Commented Jun 11, 2012 at 11:42
Are you sure that Rows[i] contains the 'option1'? You might want to try a foreach statement instead on the items in a row to vcrify that you are getting what you expect. — Chris O
– Chris O, Commented Jun 11, 2012 at 11:42

SLaks · Accepted Answer · 2012-06-11 11:42:17Z

2

test.agree is null.

You need to put a new array in the field.

answered Jun 11, 2012 at 11:42

SLaks

891k182 gold badges1.9k silver badges2k bronze badges

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

Comments

General Grey · Accepted Answer · 2012-06-11 11:44:16Z

1

Where exactly are you getting the error, on which array? By the looks of it, it has to be on the agree[] one, which you never instantiate.

try

public static int[] agree =new int[10];

but I think you might want to make agree a list since you don't know how many you need

public static List<int> agree = new List<int>;

then usage

agree.Add(Convert.ToInt32(ds.Tables[0].Rows[i]["option1"]);

and you can access it the same as an array

MessageBox.Show(agree[1].ToString());

answered Jun 11, 2012 at 11:44

General Grey

3,6982 gold badges29 silver badges32 bronze badges

Comments

HichemSeeSharp · Accepted Answer · 2012-06-11 12:25:35Z

0

Instantiate before adding values :

 SqlCommand cmd = new SqlCommand("select * from assessmenttest", con);

        SqlDataAdapter adptr = new SqlDataAdapter(cmd);

        DataSet ds = new DataSet();
        adptr.Fill(ds, "test");

        int[] arr = new int[10];
        DataTable table = ds.Tables[0];
        test.agree = new int[table.Rows.Count];
        for (int i = 0; i < table.Rows.Count; i++)
        {

            test.agree[i] = Convert.ToInt32(ds.Tables[0].Rows[i]["option1"]);
        }

edited Jun 11, 2012 at 12:25

answered Jun 11, 2012 at 12:14

HichemSeeSharp

3,3383 gold badges24 silver badges44 bronze badges

Collectives™ on Stack Overflow

how to increment index value of integer array

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related