I use Classes for connect and modify data on sql database. I am create ObjectDataSource and Connect to class ProjectsGetAll, but when I try to sort data, I get error message: you need dataset, datatable, to sort data, (something like that).
Than, I am do next:
DataTable dt = SqlHelper.ExecuteDataset(Settings.ConnectionString, CommandType.StoredProcedure, "CUSTOM_ProjectsGetAll").Tables[0];
radgrid1.datasource=dt;
radgrid1.databind(); (I am try and rebind, too)
and than in radgrid you can see message: No record to display.
Please help
Than, I am do next:
DataTable dt = SqlHelper.ExecuteDataset(Settings.ConnectionString, CommandType.StoredProcedure, "CUSTOM_ProjectsGetAll").Tables[0];
radgrid1.datasource=dt;
radgrid1.databind(); (I am try and rebind, too)
and than in radgrid you can see message: No record to display.
Please help