[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
RE: [CLOSED] binding ADO object (datareader or datatable) to GridPanel
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.
RE: [CLOSED] binding ADO object (datareader or datatable) to GridPanel
I think you should post full example which demonstrates the problem.
RE: [CLOSED] binding ADO object (datareader or datatable) to GridPanel
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.
RE: [CLOSED] binding ADO object (datareader or datatable) to GridPanel
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
RE: [CLOSED] binding ADO object (datareader or datatable) to GridPanel
thanks vladimir, really helpful, I'll retry with correct JsonReader defination later.
RE: [CLOSED] binding ADO object (datareader or datatable) to GridPanel
Thanks Vladimir...I solved thatr problem.