System.NotSupportedException：数据源不支持服务器端数据分页。

This is my code:

这是我的代码:

query = "SELECT DISTINCT TO_CHAR(date,'DD-Mon-YYYY')date, idNum, name FROM customer  ORDER BY date, idNum, name";
        dset = dbCon.ExecuteDataSet(query);
        grdSat.DataSource = query;
        grdSat.DataBind();

I got an error at here :

我在这里遇到错误:

grdSat.DataBind();

and when I debug the coding, this is what I got :

当我调试编码时,这就是我得到的:

NotSupportedException was unhandled by user code

NotSupportedException未被用户代码处理

1 个解决方案

#1

I think you should assign the dataset to the grid. Like this:

我认为你应该将数据集分配给网格。喜欢这个:

grdSat.DataSource = dset;
grdSat.DataBind();