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

  1. #1

    [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
  2. #2

    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.
  3. #3

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

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

  4. #4

    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.






  5. #5

    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


  6. #6

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

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

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

    Thanks Vladimir...I solved thatr problem.


Similar Threads

  1. Replies: 3
    Last Post: Nov 30, 2010, 11:07 AM
  2. [CLOSED] Binding Store to Datatable VERY slow...
    By iansriley in forum 1.x Legacy Premium Help
    Replies: 7
    Last Post: Oct 28, 2010, 12:57 PM
  3. Replies: 4
    Last Post: Apr 12, 2010, 1:01 PM
  4. [CLOSED] Binding List(of Object) Parsing properties
    By CMA in forum 1.x Legacy Premium Help
    Replies: 3
    Last Post: Jul 24, 2009, 7:25 AM
  5. Replies: 8
    Last Post: Sep 06, 2008, 7:02 PM

Posting Permissions