How to convert SQLce Datareader values to list?

Question

Hi all,

i want to know can we convert DataReader values to list without using foreach or loops.

i mean can we assign DataReader values to List directly??

or we have to add one bye one them using loops??? 

---

sumitk

Answer 1

Hi,

afaik, you have to use a loop

---

Regards, Nico

Answer 2

Hi Sumitk,

you need to use look structure for adding values in list. you can read your data reader until it reaches to end and one by one adding.

If there are any other library available for the same, it would be doing internally this only.

---

Thanks and Regards, Shailesh B. Davara

Answer 3

Hi,

DataRader is a forward and read only data one by one.So to add records to list one by one we have to use while loop.

eg:

SqlceDataReader dr=cmd.ExecuteReader();

while(dr.Read())

{

   // write your code here

}

---

PS.Shakeer Hussain

Answer 4

hi Syed Shakeer Hussain,

thanx for your replaycan we use Dataset insteadof dataReader for achieve my goal??

---

sumitk

Answer 5

Hi Sumit,

By using dataset also you have to use while or for loop to add data to list ..

SqlceDataAdapter da=new SqlceDataAdapter(sqlQuery);
Dataset ds=new DataSet();
da.Fill(ds);
for(int i=0;i<ds.Tables[0].Rows.Count;i++)
{
 li.Add(ds.Tables[0].Rows[i]["columnName"].ToString());
}

---

PS.Shakeer Hussain