The source contains no DataRows

Question

DataTable dt = ds.Tables[4].AsEnumerable()
    .Where(x => ((DateTime)x["EndDate"]).Date >= DateTime.Now.Date)
    .CopyToDataTable();

ds.Tables[4] has rows but it throws the exception

"The source contains no DataRows."

Any idea how to handle or get rid of this exception?

Just to make sure, you do want only entries that are for today or some day in the future? — ryanyuyu, Feb 04 '15 at 15:15
its is occuring because no records matches or full fill the query condition and result is null so here im trying to copy null to datatable ... — Mike, Feb 04 '15 at 15:15
when you are populating the DataTable could you not change the query in regards to the sql used to populate the initial DataTable..? also what if you were to change the labda expression to a Linq query.. have you thought about that as well https://msdn.microsoft.com/en-us/library/system.data.datatableextensions.asenumerable%28v=vs.110%29.aspx || https://msdn.microsoft.com/en-us/library/bb386921%28v=vs.110%29.aspx || http://forums.asp.net/t/1557426.aspx?query+CopyToDataTable+does+not+work+when+select+new+is+used — MethodMan, Feb 04 '15 at 15:17

J. Steen · Accepted Answer · 2015-02-04T15:30:04.470

57

ds.Tables[4] might, but the result of your linq-query might not, which is likely where the exception is being thrown. Split your method chaining to use interim parameters so you can be dead certain where the error is occurring. It'll also help you check for existing rows before you call CopyToDataTable() and avoid said exception.

Something like

DataTable dt = null;
var rows = ds.Tables[4].AsEnumerable()
    .Where(x => ((DateTime)x["EndDate"]).Date >= DateTime.Now.Date);

if (rows.Any())
    dt = rows.CopyToDataTable();

Another option is to use the ImportRow function on a DataTable

DataTable dt = ds.Tables[4].Clone();
var rows = ds.Tables[4].AsEnumerable()
    .Where(x => ((DateTime)x["EndDate"]).Date >= DateTime.Now.Date);

foreach (var row in rows)
    dt.ImportRow(row);

edited Feb 04 '15 at 15:30

answered Feb 04 '15 at 15:14

J. Steen

15,470
15
56
63

its is occuring because no records matches or full fill the query condition and result is null so here im trying to copy null to datatable . – Mike Feb 04 '15 at 15:17
@Mike Like I said - splitting your method chain and checking your interim results is one way to go. The comments on your question have suggested another. – J. Steen Feb 04 '15 at 15:22
@Mike I just verified both solutions, and both work with a rather simplified datamodel. There must be something else going on. – J. Steen Feb 04 '15 at 15:37

Steve · Answer 2 · 2015-02-04T15:25:07.800

Simply splitting in two lines

var rowSources = ds.Tables[4].AsEnumerable()
           .Where(x => ((DateTime)x["EndDate"]).Date >= DateTime.Now.Date);
if(rowSources.Any())
{
   DataTable dt = rowSources.CopyToDataTable();
   ... code that deals with the datatable object
}
else
{
   ... error message ?
}

This allows to check if the result contains any DataRow, if yes then you could call the CopyToDataTable method.

The source contains no DataRows

2 Answers2

Linked