Linq Statement in Datatable

Question

I'm getting the data of my Datatable into a List but i need to get only the items of a matching date how can i do a Linq statement of my datatable to filter the data on the provided date? My table Structure is taken from a stored procedure

This is my Code:

System.Data.SqlClient.SqlCommand cmd = new System.Data.SqlClient.SqlCommand("JoinedRecords", conn);
            cmd.CommandType = CommandType.StoredProcedure;
            conn.Open();
            DataTable myTable = new DataTable();
            myTable.Load(cmd.ExecuteReader());
            conn.Close();

for (var rowIndex = 0; rowIndex < myTable.Rows.Count; rowIndex++)
                {
                    var row = myTable.Rows[rowIndex];
  var rowValues = new List<string>(); 
  foreach (DataColumn column in myTable.Columns)//Where column.Date.Day == 3
  {
      rowValues.Add(row[column].ToString());
  }

var jsonRow = JsonConvert.SerializeObject(rowValues);

                    // Write current row
                    reader.Write(jsonRow);

                    // Add separating comma
                    if (rowIndex != myTable.Rows.Count - 1)
                        reader.WriteLine(",");

} How can i do this? There a data in my datatable that has datetime format

Can we see the structure of some of the data in the DataTable? — JEV, Apr 26 '16 at 15:31
See: http://stackoverflow.com/questions/10855/linq-query-on-a-datatable — stephen.vakil, Apr 26 '16 at 15:32

score 1 · Accepted Answer · answered Apr 26 '16 at 15:35

Can you try:

var myTable = new DataTable();
var rowValues = myTable.AsEnumerable().Where(r => r.Field<string>("Date") == "3").ToList();

And use a .Select() before the .ToList() to get what you want? Hard to provide more with an example of the data you have.

Auguste · Answer 2 · 2016-04-26T18:59:41.750

0

var rowValues = new List<String>();
var value = from r in rowValues
            where column.Date.Day == 3
            select r;

edited Apr 26 '16 at 18:59

answered Apr 26 '16 at 15:40

Auguste

2,007
2
17
25

im getting erros using your sintax, could it be a LinQ sintax pls? – Arturo Martinez Apr 26 '16 at 15:43
Here's a similar example from the MSDN website: https://msdn.microsoft.com/en-us/library/bb907066.aspx – Auguste Apr 26 '16 at 19:01

Linq Statement in Datatable

2 Answers2