Loading data form DataTable to SPGridview C#

Question

I'm making some webparts for myself and I want to populate SPGridview with some data.

DataTable table = /*some data*/;
SPGridview grid = new SPGridview();

// setting up SPGridview properties 

grid.DataSource = table;
grid.DataBind();

When I did that with GirdView it worked just fine. But when I tried to do that with SPGridview my webpart shows just blank page. I suppose that SPGridview need a little more from my side and if you could give me tip how to do it.

P.S. Assume that I don't know structure of data in table.

Piotr Rachwał
– Piotr Rachwał

2013-07-06 09:52:50 +00:00
Commented Jul 6, 2013 at 9:52 — Piotr Rachwał
– Piotr Rachwał, Commented Jul 6, 2013 at 9:52

vinayak hegde · Accepted Answer · 2013-07-08 06:37:48Z

1

        SPGridView myGridView = new SPGridView();
        myGridView.Enabled = true;

        myGridView.DataSource = table;
        myGridView.DataBind();


       this.Controls.Add(myGridView);

Try this code............

answered Jul 8, 2013 at 6:37

vinayak hegde

2,27227 silver badges26 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Piotr Rachwał Over a year ago

Thanks for last line I forgot about that SPGridView it's not auto-generated control and need to be added.

Piotr Rachwał · Accepted Answer · 2013-07-08 08:35:17Z

0

For some reason Microsoft disabled AutoGenerateColumns property and I don't know how to bypass without using a loop. Here is a working code:

        SPGridView _gridview = new SPGridView();
        DataTable table = /*some data*/;

        _gridview.Enabled = true;
        _gridview.AutoGenerateColumns = false;
        _gridview.Visible = true;

        foreach(DataColumn col in table.Columns)
        {
            SPBoundField field = new SPBoundField();
            field.DataField = col.ColumnName;
            _gridview.Columns.Add(field);
        }

        _gridview.DataSource = table;
        _gridview.DataBind();

        this.Controls.Add(_gridview);

answered Jul 8, 2013 at 8:35

Piotr Rachwał

4510 bronze badges

Collectives™ on Stack Overflow

Loading data form DataTable to SPGridview C#

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related