c# - How to get data from SqlDataReader to Array of arrays or Array of strings -


i'm trying populate array of arrays sqldatareader, in end rows of array filled same array of numbers.

here's t-sql code:

select      sum(memberattendants),     groups.name,     datepart(wk,convert(datetime,convert(varchar,statisticsdate),104))      stat.dbo.groupstatistics  inner join      stat.dbo.groups on groupstatistics.groupid = groups.groupid       (groups.organizationid = '4960')  group      groups.name, convert(datetime, convert(varchar, statisticsdate), 104) order      groups.name, convert(datetime, convert(varchar, statisticsdate), 104)

c# code:

sqldatareader myreader1 = cmd1.executereader();  if (myreader1.hasrows) {     int = 0, j = 0;     string[] name;     name = new string[100];     int[][] mainarray = new int[100][];      int[] activityarray;     activityarray = new int[52];     int[] weekofactivity;     weekofactivity = new int[52];     bool myflag = false;      (int mycounter = 0; mycounter <= myreader1.fieldcount; mycounter++)     {         aktivitet[mycounter] = new int[mycounter];     }      while (myreader1.read())     {       if (!myreader1.isdbnull(0) && !myreader1.isdbnull(1))       {         if (i == 0 || myreader1.getstring(1) == name[i-1]  || myflag == true)         {            if (myflag == true && myreader1.getstring(1) != name[i-1])            {               = 0;               mainarray[j] = activityarray;            }            myflag = false;            activityarray[i] = myreader1.getint32(0);            name[i] = myreader1.getstring(1);            i++;        }        else        {            mainarray[j] = activityarray;            j++;            = 0;            name[i] = myreader1.getstring(1);            activityarray[i] = myreader1.getint32(0);            i++;            myflag = true;        }    } }  mainarray[j] = activityarray;

how can fill mainarray without last activityarray overwrite rows in mainarray?

tnx

what you're missing here array reference type. when say:

mainarray[j] = activityarray

you're setting entry in mainarray point activityarray. never create new activityarray, point same place.

because you're over-writing content of activityarray, you're over-writing entries in mainarray (because same entry).

so, probably want 

while (myreader1.read()) {     activityarray = new int[52];     if (!myreader1.isdbnull(0) && !myreader1.isdbnull(1))     {

the reason have put because it's not clear me code trying do.


Comments

Post a Comment

Popular posts from this blog

matlab - Deleting rows with specific rules -

i got 20*3 cell array , need delete rows contains "137", "2" , "n:t" origin data: 't' '' '' 'np(*)' '' '' [ 137] '' '' [ 2] '' '' 'are' 'and' 'np(fcc_a1#1)' '' '' '1:t' [ 1200] [0.7052] '' [1.2051e+03] [0.7076] '' 'are' 'and' 'np(fcc_a1#3)' '' '' '2:t' [ 1200] [0.0673] '' [1.2051e+03] [0.0671] '' 'are' 'and' 'np(m23c6)' '' '' '3:t' [ 1200] [0.227...
Read more

php - MySQLi multi_query results for later use -

i using mysqli multi_query work several select statemets @ time. know how handle results, able use them later in code. example: <?php //connection stuff $query = "select name, surname database1;"; $query.= "select car, year, type database2 carid='1';"; $query.= "select product, price database3;"; if ($mysqli->multi_query($query)) { if($result = $mysqli->store_result()) { while($row = $result->fetch_row()) { --> here? } } } ?> <html> <div id='persona'> <?php foreach() { --> print name + surname } ?> </div> <div id='cars'> <?php foreach() { --> print car + year + type } ?> </div> <div id='product'> <?php foreach() { --> print product + price } ?> </div> </html> one more thing, prepared statements not possible when using multiple_query, right? there no benefit in putting unrelated queries in 1 multi ...
Read more