[CLOSED] binding ADO object (datareader or datatable) to GridPanel

Hi,

I trying to bind the ADO object to GridPanel as datasource but seems not successful. But in example on web, the binding to asp datasource object (i.e. SQLdatasoure is successful).

Below are 2 code session I try in the example. The first one is binding to a datareader object, the Employee class is a self define class, method GetEmplyees return a ADO datareader object which retrieve data from SQL server. After running, no data display in grid.

this.Store1.DataSource = Employee.GetEmployees("");
this.GridPanel1.StoreID = "Store1";
this.Store1.DataBind();

In second code I put a SQLdatasource object in page, using same connect string and same sql statement. the result is ok, and all record in table listed in grid.

//this.Store1.DataSource = SqlDataSource1;
this.GridPanel1.StoreID = "Store1";
this.Store1.DataBind();

But I really prefer using ADO code instead of datasource object. Pls help resolve, thanks.

Simon

Hi all

Am also suffering with the same problem.

this.Store1.DataSource = this.Datatable;
this.Store1.DataBind();

also i tried with sqldatasource. but it didnt show any error message. But no data in the grid.

I think you should post full example which demonstrates the problem.

Thanks For the replay..

Actually I want to know things.

1. How to bind a Dataset to Store(Array Grid.). In Coolite 0.6 Array Grid Binded with an array of objects.

So please send one example describing the above problem. I tried several methods including sqldatasource

Control. But Its having no Error but Data Is not displaying the grid.

2.If Its Possible send me one tutorial Describing the above problem.

What reader do use when bind DataTable/DataSource to Grid? You must use JsonReader

It is hard to say whats wrong without code.

In this topic you can download example which demonstrates how to bind DataTable

http://forums.ext.net/showthread.php...4393-16-1.aspx

thanks vladimir, really helpful, I'll retry with correct JsonReader defination later.

Thanks Vladimir...I solved thatr problem.