C# - Storing datatable values in an array

Question

I want to store the result of select query in an array in C#. Please tell me how to get datatable values and store in an array. My select query result contains n rows and only one column.

Dont forget to mark answer as accpeted if you got the info you want... — Pranay Rana
– Pranay Rana, Commented Apr 11, 2012 at 8:17

Heinzi · Accepted Answer · 2012-04-11 06:36:46Z

7

Replace type with the data type of your single column (e.g. int, string, ...) and myField with the name of your single column.

var myArray = (from row in myDataTable.AsEnumerable()
               select row.Field<type>("myField")).ToArray();

Using the magic of C#'s generics and type inference, your array will automatically have the correct data type (e.g. int[], string[], ...).

edited Apr 11, 2012 at 6:36

answered Apr 11, 2012 at 6:31

Heinzi

173k61 gold badges386 silver badges555 bronze badges

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

Comments

Pranay Rana · Accepted Answer · 2012-04-11 06:30:49Z

4

Try something like this

 private void getData()
        {
            SqlCeConnection conn = new SqlCeConnection("data source='c:\\northwind.sdf'; mode=Exclusive;");
            SqlCeDataAdapter da = new SqlCeDataAdapter("Select [Unit Price] from Products", conn);
            DataTable dtSource = new DataTable();
            da.Fill(dtSource);
            DataRow[] dr = new DataRow[dtSource.Rows.Count];
            dtSource.Rows.CopyTo(dr, 0);
            double[] dblPrice= Array.ConvertAll(dr, new Converter<DataRow , Double>(DataRowToDouble));

        }

        public static double DataRowToDouble(DataRow dr)
        {
            return Convert.ToDouble(dr["Unit Price"].ToString());
        }

answered Apr 11, 2012 at 6:30

Pranay Rana

177k37 gold badges244 silver badges267 bronze badges

Comments

Ashwini Verma · Accepted Answer · 2012-04-11 06:38:43Z

0

DataTable mydt = new DataTable();
ArrayList aLrows = new ArrayList();

foreach (DataRow dataRow in mydt.Rows)
{
  aLrows.Add(string.Join(";", dataRow.ItemArray.Select(item => item.ToString)));
}

answered Apr 11, 2012 at 6:38

Ashwini Verma

7,5257 gold badges39 silver badges56 bronze badges

Collectives™ on Stack Overflow

C# - Storing datatable values in an 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