Gridpanel + datasource

[Francis]

Hello everyone

This is my first time and quite new to Coolite, nontheless, I find it very attractive, and I want to give it a try.

Here's the deal:

I've developed objects such as:

 public void listrecords(GridView listuser, string strquery)
    {
           configkey k = new configkey(); // retrieve configurations from web.config
            MySql.Data.MySqlClient.MySqlConnection cn = new MySql.Data.MySqlClient.MySqlConnection(k.key("constr", ""));
            MySqlDataAdapter da = new MySqlDataAdapter(strquery, cn);
            DataSet ds = new DataSet();
            da.Fill(ds);
            listuser.DataSource = ds;
            listuser.EmptyDataText = "Não existem registos";
            listuser.DataBind();
            cn.Close();
    }

Which allows me to populate programatically a gridview with a MySQL recordset .

As I said before I understand Coolite architecture, so is there a way to do the same thing with Store + Gridpanel?

Thank's in advance
Cheers
Francis

[geoffrey.mcgill]

Hi Francis,

Welcome!

I think you just need to set the .DataSource property of the <ext:Store> to your "ds" variable, then call .DataBind().

Example

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

The GridPanel requires a separate configuration to determine which Columns you require, but its all pretty straightforward. Many samples in the Examples Explorer.

Here's a basic GridPanel to start with:

https://examples1.ext.net/#/GridPanel/ArrayGrid/Simple/

Hope this helps.