Assign ExecuteReader to Array

Question

I am trying to assign a PagedDataSource to ExecuteReader() but I get the error saying it needs to be ICollection.

I want all the data it returns as it is going to be assigned in a repeater. At first i just assigned the repeater to the cmd.ExecuteReader() and it worked ok, now they want paging and I'm not sure how to alter the query to produce an Array.

conn.Open();

var cmd = new SqlCommand("[safetyGuidanceSearch]", conn);
cmd.CommandType = CommandType.StoredProcedure;

cmd.Parameters.AddWithValue("@iwc", inwardCode);
cmd.Parameters.AddWithValue("@owc", outwardCode);

var objPds = new PagedDataSource();
objPds.DataSource = cmd.ExecuteReader();// turn into an array

What should I be trying to do?

Oscar · Accepted Answer · 2016-06-09 10:54:08Z

1

You need to fill the array first.

var result = new List<whatevertypespreturns>();
var reader = cmd.ExecuteReader();
while(reader.Read()){
    result.add(reader.GetXxxx(0);
}
objPds.DataSource = result.ToArray();

answered Jun 9, 2016 at 10:54

Oscar

14.1k9 gold badges53 silver badges84 bronze badges

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

Comments

Massaoui · Accepted Answer · 2016-06-09 12:50:36Z

0

You can do something like this

    SqlDataReader dr;
    DataTable dt = new DataTable();
    conn.Open();

    var cmd = new SqlCommand("[safetyGuidanceSearch]", conn);
    cmd.CommandType = CommandType.StoredProcedure;

    cmd.Parameters.AddWithValue("@iwc", inwardCode);
    cmd.Parameters.AddWithValue("@owc", outwardCode);

    var objPds = new PagedDataSource();
    dr = cmd.ExecuteReader();// turn into an array
    dt.load(dr);

now you can do what you want with your datatable just call it like bellow

    objPds.DataSource = dt;

answered Jun 9, 2016 at 12:50

Massaoui

587 bronze badges

Collectives™ on Stack Overflow

Assign ExecuteReader to Array

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