Gridpanel with unknown columns

Hi All,
I am trying to use Gridpanel.I succeed with the example given on the sit.
But in each example no. of columns in Grid is known.
There is a property in Gridview,AutoGenerateColumn = true,so I don't need to specify column names.
(As in my case the columns will be auto generated as per the selection criteria.)

Can I bind a dynamic datatable to Gridpanel/Store?
I tried but it's not working for me.
Please help.

I am trying hard with this.Now I have written code like this on button click.But having some problem.Please see.

JsonReader jsonread = new JsonReader();
ColumnBase[] cb = new ColumnBase[dtReturn.Columns.Count];
int i=0;
foreach (DataColumn dc in dtReturn.Columns)
{
jsonread.Fields.Add(dc.ColumnName.ToString());
cb[i].ColumnID.Insert(i,dc.ColumnName.ToString());
i++;
}
Store1.Reader.Add(jsonread);


GridPanel1.ColumnModel.Columns.Add(cb); // Getting error here.

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

Quote:

---

Originally Posted by rajputamit

I am trying hard with this.Now I have written code like this on button click.But having some problem.Please see.

JsonReader jsonread = new JsonReader();
ColumnBase[] cb = new ColumnBase[dtReturn.Columns.Count];
int i=0;
foreach (DataColumn dc in dtReturn.Columns)
{
jsonread.Fields.Add(dc.ColumnName.ToString());
cb[i].ColumnID.Insert(i,dc.ColumnName.ToString());
i++;
}
Store1.Reader.Add(jsonread);


GridPanel1.ColumnModel.Columns.Add(cb); // Getting error here.

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

---

You have some mistakes. Please change your code same as below code:

Code:

---


        JsonReader jsonread = new JsonReader();
        ColumnBase[] cb = new ColumnBase[dt.Columns.Count];
        int i = 0;
        foreach (DataColumn dc in dt.Columns)
        {
            jsonread.Fields.Add(dc.ColumnName.ToString());
            cb[i] = new Ext.Net.Column();
            cb[i].ColumnID = dc.ColumnName.ToString();
            i++;
        }

        Store1.Reader.Add(jsonread);
        GV_Preview.ColumnModel.Columns.AddRange(cb);
        Store1.DataSource = dt;
        Store1.DataBind();
        Store1.Render(GV_Preview);
        GV_Preview.Render(pnlPreview);

---

In addition, I suppose this method is better:

Code:

---


        foreach (DataColumn dc in dt.Columns)
        {
            Store1.Reader[0].Fields.Add(dc.ColumnName);
            Ext.Net.ColumnBase col = new Ext.Net.Column();
            col.DataIndex = dc.ColumnName;
            col.Width = new Unit("85px");
            col.Wrap = false;
            col.Sortable = false;
            col.Align = Ext.Net.Alignment.Center;
            GridPanel1.AddColumn(col);
        }

---