Sunday, June 1, 2008

SPGridView - Using a data table as the datasource

Loading a SPList of items into a datatable, then binding this datatable to the SPGridView.

SPGridView gridView = new SPGridView();

DataTable dt = new DataTable();

dt = new DataTable();
dt.Columns.Add("First Name");
dt.Columns.Add("Last Name");
dt.Columns.Add("Street Address");
dt.Columns.Add("Email Address");

foreach(SPListItem item in {insert SPList}.Items)
{
DataRow dr = dt.NewRow();
dr["First Name"] = item["First Name];
dr["Last Name"] = item["Last Name"];
dr["Street Address"] = item["Street Address"];
dr["Email Address"] = itemS["Email Address"];
dt.Rows.Add(dr);
}

gridView.DataSource = dt;
gridView.DataBind();

No comments: