IListSource does not contain any data sources

Question

So what does this exactly means?

Some advised that to circumvent around this error, only bind a gridview to a dataset when the rows count of the datatable is greater than zero.

but how about if for example your search yielded no record returned, so your datatable would have no rows, but still, you can still bind to the dataset?

Aside from checking if rows are in the dataset (or datatable), how would I ensure that the ilist contains valid datasource?

what's the best method for this?

score 7 · Accepted Answer · edited Dec 19 '17 at 11:38

7

Make sure you use this:

if (!this.IsPostBack)
{
}

Also you can check the dataSet.Tables.Count > 0 then return dataSet else return null;

I think the DataSet return have Count = 0

edited Dec 19 '17 at 11:38

DreamTeK

32,537
27
112
171

answered Apr 15 '09 at 21:00

DevMania

2,311
4
25
43

score 1 · Answer 2 · answered Jan 20 '14 at 10:53

1

Please check your connection string. In my case, the connection string was the problem.

answered Jan 20 '14 at 10:53

Gautam Jain

6,789
10
48
67

score 1 · Answer 3 · answered Aug 07 '14 at 23:51

Old thread, but just wanted to let people know that I got this error recently (while looking at our legacy system) and turns out the issue was related to binding a datasource directly to a dataset.

Dim MyDs As new Dataset
MyDs = GetFromDataBase()

MyDropDownList.Datasource = MyDs

The strange thing was that I have done code like this for years and years, plus it worked fine on my local machine (best Dev line ever =P) But on the server it just kept crashing out.

I had to do

MyDropDownList.Datasource = MyDs.Tables(0)

Maybe this is something to do with .Net 4.0 on Windows 2008 Server, not sure, but hopefully this might help someone wasting 30mins of bug hunting for something that your eyes say is perfectly fine (allbeit legacy) code.

I was in precisely the same situation. Found it strange that the app was working perfectly fine in IIS on my local machine. Change the line as follows: `gridView.DataSource = dataSet.Tables[0];` and presto — Carel, Feb 11 '16 at 08:31

score 0 · Answer 4 · edited Apr 07 '13 at 14:02

0

The IListSource does not contain any data sources.

Why is this error occur when the web site is hosted in IIS server.

Is this Because of the Data source not connecting properly with the server.

I'm using this postback check while calling the method.

if (!this.IsPostBack) { ... }

edited Apr 07 '13 at 14:02

p.s.w.g

146,324
30
291
331

answered Apr 06 '13 at 05:39

user620755

1
3

score 0 · Answer 5 · answered Jul 16 '13 at 11:47

0

make sure that you closed the connection after binding data to the gridview

answered Jul 16 '13 at 11:47

sivakumar

1

score -1 · Answer 6 · answered Apr 15 '20 at 09:57

-1

In my case, my page was supposed to redirect to another page, but that URL didn't exist. So I got this error. Please check the URL if you are redirecting to some other page.

answered Apr 15 '20 at 09:57

vignesh kamath

1
1

IListSource does not contain any data sources

6 Answers6