Creating a RadGrid Programmatically
This help article describes two options for creating a RadGrid instance dynamically, and provides code examples.
You can declare the RadGrid control in the ASPX file and define its structure in the code-behind.
You can create the RadGrid entirely in the code-behind.
This article demonstrates how to create and configure the RadGrid control programmatically on the code-behind, given that the data source structure will remain the same. If you want to dynamically change the columns of the grid depending on user selection or some dynamic condition (remove or add columns with different DataFields than the initial loaded structure), this might mess up the ViewState. For this scenario, please refer to the next Changing the Grid Structure Dynamically on Postback article.
When defining the structure of a hierarchical grid (by either method), you should follow these rules:
Create the GridTableView objects for every detail table. You do not need to create an object for the MasterTableView of the grid, as this is created automatically when the RadGrid itself is created.
Add each detail table to the DetailTables collection of its parent table.
-
Ensure that each table in the grid has its own data source.
If you are using declarative data sources, set the DataSourceID property of each table to the ID of a DataSource object. For each parent table, set the DataKeyNames property to an array containing the names of each field in the table's data source that is used to link to detail tables. For each detail table, add GridRelationFields objects to the ParentTableRelation collection, each of which specifies a link between a field in the detail table to a field in the DataKeyNames array of the parent table.
If you are not using declarative data sources, add event handlers for the NeedDataSource and DetailTableDataBind events. In the DetailTableDataBind event handler, you can determine which data source should be related to the current table view by checking whether the GetDataKeyValue method of the detail table's ParentItem returns a value.
Hierarchical structure is not supported with simple data binding (calling DataBind()).
Dynamically Defining the Structure of a Statically-declared Grid
To define the structure of a RadGrid control that is declared in the ASPX page, use the Page_Load event handler. Columns and detail tables should be added to the corresponding collection first, before the values for their properties are set. This is important because no ViewState is managed for the object before it has been added to the corresponding collection.
Be sure to check that IsPostBack is False . Otherwise, you will end up adding the same objects to the RadGrid multiple times.
<telerik:RadGrid RenderMode="Lightweight" ID="RadGrid1" runat="server" />
<asp:SqlDataSource ID="SqlDataSource1"
ConnectionString="<%$ ConnectionStrings:NorthwindConnectionString %>"
ProviderName="System.Data.SqlClient"
SelectCommand="SELECT * FROM Customers" runat="server"></asp:SqlDataSource>
<asp:SqlDataSource ID="SqlDataSource2"
ConnectionString="<%$ ConnectionStrings:NorthwindConnectionString %>"
ProviderName="System.Data.SqlClient"
SelectCommand="SELECT * FROM Orders Where CustomerID = @CustomerID" runat="server">
<SelectParameters>
<asp:SessionParameter Name="CustomerID" SessionField="CustomerID" Type="string" />
</SelectParameters>
</asp:SqlDataSource>
<asp:SqlDataSource ID="SqlDataSource3"
ConnectionString="<%$ ConnectionStrings:NorthwindConnectionString %>"
ProviderName="System.Data.SqlClient"
SelectCommand="SELECT * FROM [Order Details] where OrderID = @OrderID" runat="server">
<SelectParameters>
<asp:SessionParameter Name="OrderID" SessionField="OrderID" Type="Int32" />
</SelectParameters>
</asp:SqlDataSource>
protected void Page_Load(object sender, System.EventArgs e)
{
if (!IsPostBack)
{
RadGrid1.DataSourceID = "SqlDataSource1";
RadGrid1.MasterTableView.DataKeyNames = new string[] { "CustomerID" };
RadGrid1.Width = Unit.Percentage(98);
RadGrid1.PageSize = 15;
RadGrid1.AllowPaging = true;
RadGrid1.PagerStyle.Mode = GridPagerMode.NextPrevAndNumeric;
RadGrid1.AutoGenerateColumns = false;
RadGrid1.Skin = "Web20";
//Add Customers table
RadGrid1.MasterTableView.Width = Unit.Percentage(100);
GridBoundColumn boundColumn;
boundColumn = new GridBoundColumn();
RadGrid1.MasterTableView.Columns.Add(boundColumn);
boundColumn.DataField = "CustomerID";
boundColumn.HeaderText = "CustomerID";
boundColumn = new GridBoundColumn();
RadGrid1.MasterTableView.Columns.Add(boundColumn);
boundColumn.DataField = "ContactName";
boundColumn.HeaderText = "Contact Name";
//Add Orders table
GridTableView tableViewOrders = new GridTableView(RadGrid1);
RadGrid1.MasterTableView.DetailTables.Add(tableViewOrders);
tableViewOrders.DataSourceID = "SqlDataSource2";
tableViewOrders.Width = Unit.Percentage(100);
GridRelationFields relationFields = new GridRelationFields();
tableViewOrders.ParentTableRelation.Add(relationFields);
relationFields.MasterKeyField = "CustomerID";
relationFields.DetailKeyField = "CustomerID";
boundColumn = new GridBoundColumn();
tableViewOrders.Columns.Add(boundColumn);
boundColumn.DataField = "OrderID";
boundColumn.HeaderText = "OrderID";
boundColumn = new GridBoundColumn();
tableViewOrders.Columns.Add(boundColumn);
boundColumn.DataField = "OrderDate";
boundColumn.HeaderText = "Date Ordered";
}
}
Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
If Not IsPostBack Then
RadGrid1.DataSourceID = "SqlDataSource1"
RadGrid1.MasterTableView.DataKeyNames = New String() {"CustomerID"}
RadGrid1.Width = Unit.Percentage(98)
RadGrid1.PageSize = 15
RadGrid1.AllowPaging = True
RadGrid1.PagerStyle.Mode = GridPagerMode.NextPrevAndNumeric
RadGrid1.AutoGenerateColumns = False
RadGrid1.Skin = "Web20"
'Add Customers table
RadGrid1.MasterTableView.Width = Unit.Percentage(100)
Dim boundColumn As GridBoundColumn
boundColumn = New GridBoundColumn()
RadGrid1.MasterTableView.Columns.Add(boundColumn)
boundColumn.DataField = "CustomerID"
boundColumn.HeaderText = "CustomerID"
boundColumn = New GridBoundColumn()
RadGrid1.MasterTableView.Columns.Add(boundColumn)
boundColumn.DataField = "ContactName"
boundColumn.HeaderText = "Contact Name"
'Add Orders table
Dim tableViewOrders As New GridTableView(RadGrid1)
RadGrid1.MasterTableView.DetailTables.Add(tableViewOrders)
tableViewOrders.DataSourceID = "SqlDataSource2"
tableViewOrders.Width = Unit.Percentage(100)
Dim relationFields As New GridRelationFields()
tableViewOrders.ParentTableRelation.Add(relationFields)
relationFields.MasterKeyField = "CustomerID"
relationFields.DetailKeyField = "CustomerID"
boundColumn = New GridBoundColumn()
tableViewOrders.Columns.Add(boundColumn)
boundColumn.DataField = "OrderID"
boundColumn.HeaderText = "OrderID"
boundColumn = New GridBoundColumn()
tableViewOrders.Columns.Add(boundColumn)
boundColumn.DataField = "OrderDate"
boundColumn.HeaderText = "Date Ordered"
End If
End Sub
RadGrid does not support mixing declarative grid columns with grid columns added dynamically at runtime. You should either create all the columns in the grid programmatically, or else define them all in the ASPX file.
Creating columns in the Page_Load event handler does not work for template columns. For the controls inside a template to persist their ViewState , the grid must be generated completely in the code-behind using the Page_Init event (see below). That way, template controls are instantiated before the LoadViewState event of the page.
Creating the Grid Entirely in the Code Behind
When generating a RadGrid instance entirely in code, you should use the Page_Init or Page_Load event handlers.
Creating a RadGrid on Page_Load
When creating a RadGrid on a Page_Load event, the columns or detail tables should be added to the corresponding collection first and then values for the properties of this instance should be set.
Properties are set only at initial load, while event handlers are attached on every postback.
<asp:PlaceHolder ID="PlaceHolder1" runat="server"></asp:PlaceHolder>
protected void Page_Load(object sender, System.EventArgs e)
{
RadGrid RadGrid1 = new RadGrid();
RadGrid1.ID = "RadGrid1";
// Attach event handlers on every postback
RadGrid1.ItemDataBound += RadGrid1_ItemDataBound;
// Add RadGrid to the Controls collection of the placeholder
PlaceHolder1.Controls.Add(RadGrid1);
if (!IsPostBack)
{
RadGrid1.DataSourceID = "SqlDataSource1";
RadGrid1.MasterTableView.DataKeyNames = new string[] { "CustomerID" };
RadGrid1.AllowPaging = true;
RadGrid1.MasterTableView.AutoGenerateColumns = false;
RadGrid1.PageSize = 15;
GridBoundColumn boundColumn;
boundColumn = new GridBoundColumn();
RadGrid1.MasterTableView.Columns.Add(boundColumn);
boundColumn.DataField = "CustomerID";
boundColumn.HeaderText = "CustomerID";
boundColumn = new GridBoundColumn();
RadGrid1.MasterTableView.Columns.Add(boundColumn);
boundColumn.DataField = "ContactName";
boundColumn.HeaderText = "Contact Name";
}
}
protected void RadGrid1_ItemDataBound(object sender, GridItemEventArgs e)
{
RadGrid grid = sender as RadGrid;
// Some logic here
}
Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs)
Dim RadGrid1 As New RadGrid()
RadGrid1.ID = "RadGrid1"
'Attach event handlers on every postback
AddHandler RadGrid1.ItemDataBound, AddressOf RadGrid1_ItemDataBound
'Add RadGrid to the Controls collection of the placeholder
PlaceHolder1.Controls.Add(RadGrid1)
If Not IsPostBack Then
RadGrid1.DataSourceID = "SqlDataSource1"
RadGrid1.MasterTableView.DataKeyNames = New String() {"CustomerID"}
RadGrid1.AllowPaging = True
RadGrid1.MasterTableView.AutoGenerateColumns = False
RadGrid1.PageSize = 15
Dim boundColumn As GridBoundColumn
boundColumn = New GridBoundColumn()
RadGrid1.MasterTableView.Columns.Add(boundColumn)
boundColumn.DataField = "CustomerID"
boundColumn.HeaderText = "CustomerID"
boundColumn = New GridBoundColumn()
RadGrid1.MasterTableView.Columns.Add(boundColumn)
boundColumn.DataField = "ContactName"
boundColumn.HeaderText = "Contact Name"
End If
End Sub
Protected Sub RadGrid1_ItemDataBound(sender As Object, e As GridItemEventArgs)
Dim grid As RadGrid = TryCast(sender, RadGrid)
'Some logic here
End Sub
Creating a RadGrid on Page_Init
When generating a grid in the Page_Init event handler, grid columns should be added to the Columns collection of the MasterTableView after their attributes are set.
No ViewState is required for grid structure to be persisted as it is recreated on each page initialization:
<asp:PlaceHolder ID="PlaceHolder1" runat="server" />
<asp:SqlDataSource ID="SqlDataSource4"
ConnectionString="<%$ ConnectionStrings:NorthwindConnectionString %>"
ProviderName="System.Data.SqlClient"
SelectCommand="SELECT * FROM Customers" runat="server"></asp:SqlDataSource>
<asp:SqlDataSource ID="SqlDataSource5"
ConnectionString="<%$ ConnectionStrings:NorthwindConnectionString %>"
ProviderName="System.Data.SqlClient"
SelectCommand="SELECT * FROM Orders Where CustomerID = @CustomerID" runat="server">
<SelectParameters>
<asp:SessionParameter Name="CustomerID" SessionField="CustomerID" Type="string" />
</SelectParameters>
</asp:SqlDataSource>
protected void Page_Init(object sender, System.EventArgs e)
{
DefineGridStructure();
}
private void DefineGridStructure()
{
RadGrid grid = new RadGrid();
grid.ID = "RadGrid1";
grid.DataSourceID = "SqlDataSource1";
grid.Skin = "Vista";
grid.Width = Unit.Percentage(100);
grid.PageSize = 15;
grid.AllowPaging = true;
grid.PagerStyle.Mode = GridPagerMode.NextPrevAndNumeric;
grid.AutoGenerateColumns = false;
//Add Customers table
grid.MasterTableView.Width = Unit.Percentage(100);
grid.MasterTableView.DataKeyNames = new string[] { "CustomerID" };
GridBoundColumn boundColumn = new GridBoundColumn();
boundColumn.DataField = "CustomerID";
boundColumn.HeaderText = "Customer ID";
grid.MasterTableView.Columns.Add(boundColumn);
boundColumn = new GridBoundColumn();
boundColumn.DataField = "ContactName";
boundColumn.HeaderText = "Contact Name";
grid.MasterTableView.Columns.Add(boundColumn);
//Add Orders table
GridTableView tableViewOrders = new GridTableView(grid);
tableViewOrders.DataSourceID = "SqlDataSource2";
tableViewOrders.Width = Unit.Percentage(100);
GridRelationFields relationFields = new GridRelationFields();
relationFields.MasterKeyField = "CustomerID";
relationFields.DetailKeyField = "CustomerID";
tableViewOrders.ParentTableRelation.Add(relationFields);
boundColumn = new GridBoundColumn();
boundColumn.DataField = "OrderID";
boundColumn.HeaderText = "OrderID";
tableViewOrders.Columns.Add(boundColumn);
boundColumn = new GridBoundColumn();
boundColumn.DataField = "OrderDate";
boundColumn.HeaderText = "Date Ordered";
tableViewOrders.Columns.Add(boundColumn);
grid.MasterTableView.DetailTables.Add(tableViewOrders);
// Add the grid to the placeholder
this.PlaceHolder1.Controls.Add(grid);
}
Protected Sub Page_Init(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Init
DefineGridStructure()
End Sub
Private Sub DefineGridStructure()
Dim grid As New RadGrid()
grid.ID = "RadGrid1"
grid.DataSourceID = "SqlDataSource1"
grid.Skin = "Vista"
grid.Width = Unit.Percentage(100)
grid.PageSize = 15
grid.AllowPaging = True
grid.PagerStyle.Mode = GridPagerMode.NextPrevAndNumeric
grid.AutoGenerateColumns = False
'Add Customers table
grid.MasterTableView.Width = Unit.Percentage(100)
grid.MasterTableView.DataKeyNames = New String() {"CustomerID"}
Dim boundColumn As New GridBoundColumn()
boundColumn.DataField = "CustomerID"
boundColumn.HeaderText = "Customer ID"
grid.MasterTableView.Columns.Add(boundColumn)
boundColumn = New GridBoundColumn()
boundColumn.DataField = "ContactName"
boundColumn.HeaderText = "Contact Name"
grid.MasterTableView.Columns.Add(boundColumn)
'Add Orders table
Dim tableViewOrders As New GridTableView(grid)
tableViewOrders.DataSourceID = "SqlDataSource2"
tableViewOrders.Width = Unit.Percentage(100)
Dim relationFields As New GridRelationFields()
relationFields.MasterKeyField = "CustomerID"
relationFields.DetailKeyField = "CustomerID"
tableViewOrders.ParentTableRelation.Add(relationFields)
boundColumn = New GridBoundColumn()
boundColumn.DataField = "OrderID"
boundColumn.HeaderText = "OrderID"
tableViewOrders.Columns.Add(boundColumn)
boundColumn = New GridBoundColumn()
boundColumn.DataField = "OrderDate"
boundColumn.HeaderText = "Date Ordered"
tableViewOrders.Columns.Add(boundColumn)
grid.MasterTableView.DetailTables.Add(tableViewOrders)
' Add the grid to the placeholder
Me.PlaceHolder1.Controls.Add(grid)
End Sub
When creating a grid in the Page_Init event handler, you can use the Page_Load event to add an AJAX setting for the grid to a RadAjaxManager so that the grid uses asynchronous callbacks.
Creating a Hierarchical Grid Programmatically
You should follow these basic steps in order to create hierarchical RadGrid programmatically in the code-behind (having a data source control for data content generation):
Create the grid dynamically in the Page_Init handler of the page by calling its constructor.
Specify the preferred settings for your grid instance through its properties.
Create columns for the grid dynamically. Keep in mind that you have to first set their properties and then add them to the MasterTableView/GridTableView collection (discussed in the first paragraph of this same topic). Thus, their ViewState will be properly persisted (as LoadViewState is raised after the Init event of the page).
Set the proper ParentTableRelations for the GridTableViews (along with their MasterKeyField and DetailKeyField attributes) and DataKeyNames for the MasterTableView/GridTableViews in the code-behind of the page.
Assign data sources (through the DataSourceID attribute) for each table in the grid hierarchy.If you do not want to use declarative relations, generate the data in the NeedDataSource/DetailTableDataBind handlers of the grid. On DetailTableDataBind you can determine which data source should be related to the currently bound GridTableView by checking its Name/DataSourceID property. Here, the Name property must have a unique value for each detail table (this value has to be defined previously by the developer) and the DataSourceID is the ID of the DataSource control responsible for the corresponding detail table content generation.
Here is a complete source code sample:
private void DefineGridStructure()
{
RadGrid RadGrid1 = new RadGrid();
RadGrid1.DataSourceID = "SqlDataSource1";
RadGrid1.MasterTableView.DataKeyNames = new string[] { "CustomerID" };
RadGrid1.Skin = "Default";
RadGrid1.Width = Unit.Percentage(100);
RadGrid1.PageSize = 15;
RadGrid1.AllowPaging = true;
RadGrid1.AutoGenerateColumns = false;
//Add columns
GridBoundColumn boundColumn;
boundColumn = new GridBoundColumn();
boundColumn.DataField = "CustomerID";
boundColumn.HeaderText = "CustomerID";
RadGrid1.MasterTableView.Columns.Add(boundColumn);
boundColumn = new GridBoundColumn();
boundColumn.DataField = "ContactName";
boundColumn.HeaderText = "Contact Name";
RadGrid1.MasterTableView.Columns.Add(boundColumn);
//Detail table - Orders (II in hierarchy level)
GridTableView tableViewOrders = new GridTableView(RadGrid1);
tableViewOrders.DataSourceID = "SqlDataSource2";
tableViewOrders.DataKeyNames = new string[] { "OrderID" };
GridRelationFields relationFields = new GridRelationFields();
relationFields.MasterKeyField = "CustomerID";
relationFields.DetailKeyField = "CustomerID";
tableViewOrders.ParentTableRelation.Add(relationFields);
RadGrid1.MasterTableView.DetailTables.Add(tableViewOrders);
//Add columns
boundColumn = new GridBoundColumn();
boundColumn.DataField = "OrderID";
boundColumn.HeaderText = "OrderID";
tableViewOrders.Columns.Add(boundColumn);
boundColumn = new GridBoundColumn();
boundColumn.DataField = "OrderDate";
boundColumn.HeaderText = "Date Ordered";
tableViewOrders.Columns.Add(boundColumn);
//Detail table Order-Details (III in hierarchy level)
GridTableView tableViewOrderDetails = new GridTableView(RadGrid1);
tableViewOrderDetails.DataSourceID = "SqlDataSource3";
tableViewOrderDetails.DataKeyNames = new string[] { "OrderID" };
GridRelationFields relationFields2 = new GridRelationFields();
relationFields2.MasterKeyField = "OrderID";
relationFields2.DetailKeyField = "OrderID";
tableViewOrderDetails.ParentTableRelation.Add(relationFields2);
tableViewOrders.DetailTables.Add(tableViewOrderDetails);
boundColumn = new GridBoundColumn();
boundColumn.DataField = "UnitPrice";
boundColumn.HeaderText = "Unit Price";
tableViewOrderDetails.Columns.Add(boundColumn);
boundColumn = new GridBoundColumn();
boundColumn.DataField = "Quantity";
boundColumn.HeaderText = "Quantity";
tableViewOrderDetails.Columns.Add(boundColumn);
//Add the RadGrid instance to the controls
this.PlaceHolder1.Controls.Add(RadGrid1);
}
protected void Page_Init(object source, System.EventArgs e)
{
DefineGridStructure();
}
Private Sub DefineGridStructure()
Dim RadGrid1 As RadGrid = New RadGrid
RadGrid1.DataSourceID = "SqlDataSource1"
RadGrid1.MasterTableView.DataKeyNames = New String() {"CustomerID"}
RadGrid1.Skin = "Default"
RadGrid1.Width = Unit.Percentage(100)
RadGrid1.PageSize = 15
RadGrid1.AllowPaging = True
RadGrid1.AutoGenerateColumns = False
'Master table - Customers (I in hierarchy level)
'Add columnsn
Dim boundColumn As GridBoundColumn
boundColumn = New GridBoundColumn
boundColumn.DataField = "CustomerID"
boundColumn.HeaderText = "CustomerID"
RadGrid1.MasterTableView.Columns.Add(boundColumn)
boundColumn = New GridBoundColumn
boundColumn.DataField = "ContactName"
boundColumn.HeaderText = "Contact Name"
RadGrid1.MasterTableView.Columns.Add(boundColumn)
'Detail table - Orders (II in hierarchy level)
Dim tableViewOrders As New GridTableView(RadGrid1)
tableViewOrders.DataSourceID = "SqlDataSource2"
tableViewOrders.DataKeyNames = New String() {"OrderID"}
Dim relationFields As GridRelationFields = New GridRelationFields()
relationFields.MasterKeyField = "CustomerID"
relationFields.DetailKeyField = "CustomerID"
tableViewOrders.ParentTableRelation.Add(relationFields)
RadGrid1.MasterTableView.DetailTables.Add(tableViewOrders)
'Add columns
boundColumn = New GridBoundColumn
boundColumn.DataField = "OrderID"
boundColumn.HeaderText = "OrderID"
tableViewOrders.Columns.Add(boundColumn)
boundColumn = New GridBoundColumn
boundColumn.DataField = "OrderDate"
boundColumn.HeaderText = "Date Ordered"
tableViewOrders.Columns.Add(boundColumn)
'Detail table Order-Details (III in hierarchy level)
Dim tableViewOrderDetails As New GridTableView(RadGrid1)
tableViewOrderDetails.DataSourceID = "SqlDataSource3"
tableViewOrderDetails.DataKeyNames = New String() {"OrderID"}
Dim relationFields2 As GridRelationFields = New GridRelationFields()
relationFields2.MasterKeyField = "OrderID"
relationFields2.DetailKeyField = "OrderID"
tableViewOrderDetails.ParentTableRelation.Add(relationFields2)
tableViewOrders.DetailTables.Add(tableViewOrderDetails)
boundColumn = New GridBoundColumn
boundColumn.DataField = "UnitPrice"
boundColumn.HeaderText = "Unit Price"
tableViewOrderDetails.Columns.Add(boundColumn)
boundColumn = New GridBoundColumn
boundColumn.DataField = "Quantity"
boundColumn.HeaderText = "Quantity"
tableViewOrderDetails.Columns.Add(boundColumn)
'Add the RadGrid instance to the controls
Me.PlaceHolder1.Controls.Add(RadGrid1)
End Sub
Private Sub Page_Init(ByVal sender As Object, ByVal e As EventArgs) Handles MyBase.Init
DefineGridStructure()
End Sub
Creating Template Columns Programmatically
When creating template columns programmatically, the grid must be generated completely in the code-behind using the Page_Init event. Then, you must create the templates dynamically in the code-behind and assign them to the ItemTemplate and EditItemTemplate properties of the column. To create a template dynamically, you must define a custom class that implements the ITemplate interface. Then you can assign an instance of this class to the ItemTemplate or EditTemplateTemplate property of the GridTemplateColumn object.
Column templates must be added in the Page_Init event handler, so that the template controls can be added to the ViewState .
The following example shows a Page_Init event handler that creates a grid, which includes a template column that shows data from multiple fields:
protected void Page_Init(object sender, EventArgs e)
{
RadGrid grid = new RadGrid();
grid.AutoGenerateColumns = false;
grid.DataSourceID = "SqlDataSource1";
string templateColumnName = "ContactName";
GridTemplateColumn templateColumn = new GridTemplateColumn();
templateColumn.ItemTemplate = new MyTemplate(templateColumnName);
templateColumn.HeaderText = templateColumnName;
GridBoundColumn boundColumn1 = new GridBoundColumn();
boundColumn1.DataField = "ContactName";
boundColumn1.UniqueName = "ConactName";
boundColumn1.HeaderText = "Bound Column";
grid.MasterTableView.Columns.Add(templateColumn);
grid.MasterTableView.Columns.Add(boundColumn1);
grid.AllowPaging = true;
grid.PageSize = 3;
grid.Skin = "Outlook";
PlaceHolder1.Controls.Add(grid);
}
private class MyTemplate : ITemplate
{
protected LiteralControl lControl;
protected RequiredFieldValidator validatorTextBox;
protected HyperLink searchGoogle;
protected TextBox textBox;
protected CheckBox boolValue;
private string colname;
public MyTemplate(string cName)
{
colname = cName;
}
public void InstantiateIn(System.Web.UI.Control container)
{
lControl = new LiteralControl();
lControl.ID = "lControl";
lControl.DataBinding += new EventHandler(lControl_DataBinding);
textBox = new TextBox();
textBox.ID = "templateColumnTextBox";
validatorTextBox = new RequiredFieldValidator();
validatorTextBox.ControlToValidate = "templateColumnTextBox";
validatorTextBox.ErrorMessage = "*";
searchGoogle = new HyperLink();
searchGoogle.ID = "searchGoogle";
searchGoogle.DataBinding += new EventHandler(searchGoogle_DataBinding);
boolValue = new CheckBox();
boolValue.ID = "boolValue";
boolValue.DataBinding += new EventHandler(boolValue_DataBinding);
boolValue.Enabled = false;
Table table = new Table();
TableRow row1 = new TableRow();
TableRow row2 = new TableRow();
TableCell cell11 = new TableCell();
TableCell cell12 = new TableCell();
TableCell cell21 = new TableCell();
TableCell cell22 = new TableCell();
row1.Cells.Add(cell11);
row1.Cells.Add(cell12);
row2.Cells.Add(cell21);
row2.Cells.Add(cell22);
table.Rows.Add(row1);
table.Rows.Add(row2);
cell11.Text = colname + ": ";
cell12.Controls.Add(lControl);
cell21.Text = "Search Google for: ";
cell22.Controls.Add(searchGoogle);
container.Controls.Add(textBox);
container.Controls.Add(validatorTextBox);
container.Controls.Add(table);
container.Controls.Add(new LiteralControl("<br />"));
container.Controls.Add(boolValue);
}
void boolValue_DataBinding(object sender, EventArgs e)
{
CheckBox cBox = (CheckBox)sender;
GridDataItem container = (GridDataItem)cBox.NamingContainer;
cBox.Checked = (bool)((DataRowView)container.DataItem)["Bool"];
}
void searchGoogle_DataBinding(object sender, EventArgs e)
{
HyperLink link = (HyperLink)sender;
GridDataItem container = (GridDataItem)link.NamingContainer;
link.Text = ((DataRowView)container.DataItem)[colname].ToString();
link.NavigateUrl = "http://www.google.com/search?hl=en&q=" + ((DataRowView)container.DataItem)["ContactName"].ToString() + "&btnG=Google+Search";
}
public void lControl_DataBinding(object sender, EventArgs e)
{
LiteralControl l = (LiteralControl)sender;
GridDataItem container = (GridDataItem)l.NamingContainer;
l.Text = ((DataRowView)container.DataItem)[colname].ToString() + "<br />";
}
}
Protected Sub Page_Init(ByVal sender As Object, ByVal e As EventArgs) Handles Me.Init
Dim grid As New RadGrid()
grid.AutoGenerateColumns = False
grid.DataSourceID = "SqlDataSource1"
Dim templateColumnName As String = "ContactName"
Dim templateColumn As New GridTemplateColumn()
templateColumn.ItemTemplate = New MyTemplate(templateColumnName)
templateColumn.HeaderText = templateColumnName
Dim boundColumn1 As New GridBoundColumn()
boundColumn1.DataField = "ContactName"
boundColumn1.UniqueName = "ConactName"
boundColumn1.HeaderText = "Bound Column"
grid.MasterTableView.Columns.Add(templateColumn)
grid.MasterTableView.Columns.Add(boundColumn1)
grid.AllowPaging = True
grid.PageSize = 3
grid.Skin = "Outlook"
PlaceHolder1.Controls.Add(grid)
End Sub
Private Class MyTemplate
Implements ITemplate
Protected lControl As LiteralControl
Protected validatorTextBox As RequiredFieldValidator
Protected searchGoogle As HyperLink
Protected textBox As TextBox
Protected boolValue As CheckBox
Private colname As String
Public Sub New(ByVal cName As String)
colname = cName
End Sub
Public Sub InstantiateIn(ByVal container As System.Web.UI.Control) Implements ITemplate.InstantiateIn
lControl = New LiteralControl()
lControl.ID = "lControl"
AddHandler lControl.DataBinding, AddressOf lControl_DataBinding
textBox = New TextBox()
textBox.ID = "templateColumnTextBox"
validatorTextBox = New RequiredFieldValidator()
validatorTextBox.ControlToValidate = "templateColumnTextBox"
validatorTextBox.ErrorMessage = "*"
searchGoogle = New HyperLink()
searchGoogle.ID = "searchGoogle"
AddHandler searchGoogle.DataBinding, _
AddressOf searchGoogle_DataBinding
boolValue = New CheckBox()
boolValue.ID = "boolValue"
AddHandler boolValue.DataBinding, _
AddressOf boolValue_DataBinding
boolValue.Enabled = False
Dim table As New Table()
Dim row1 As New TableRow()
Dim row2 As New TableRow()
Dim cell11 As New TableCell()
Dim cell12 As New TableCell()
Dim cell21 As New TableCell()
Dim cell22 As New TableCell()
row1.Cells.Add(cell11)
row1.Cells.Add(cell12)
row2.Cells.Add(cell21)
row2.Cells.Add(cell22)
table.Rows.Add(row1)
table.Rows.Add(row2)
cell11.Text = colname + ": "
cell12.Controls.Add(lControl)
cell21.Text = "Search Google for: "
cell22.Controls.Add(searchGoogle)
container.Controls.Add(textBox)
container.Controls.Add(validatorTextBox)
container.Controls.Add(table)
container.Controls.Add(New LiteralControl("<br />"))
container.Controls.Add(boolValue)
End Sub
Sub boolValue_DataBinding(ByVal sender As Object, ByVal e As EventArgs)
Dim cBox As CheckBox = DirectCast(sender, CheckBox)
Dim container As GridDataItem = DirectCast(cBox.NamingContainer, GridDataItem)
cBox.Checked = DirectCast((DirectCast(container.DataItem, DataRowView))("Bool"), Boolean)
End Sub
Sub searchGoogle_DataBinding(ByVal sender As Object, ByVal e As EventArgs)
Dim link As HyperLink = DirectCast(sender, HyperLink)
Dim container As GridDataItem = DirectCast(link.NamingContainer, GridDataItem)
link.Text = (DirectCast(container.DataItem, DataRowView))(colname).ToString()
link.NavigateUrl = "http://www.google.com/search?hl=en&q=" + _
(DirectCast(container.DataItem, DataRowView))("ContactName").ToString() + "&btnG=Google+Search"
End Sub
Public Sub lControl_DataBinding(ByVal sender As Object, ByVal e As EventArgs)
Dim l As LiteralControl = DirectCast(sender, LiteralControl)
Dim container As GridDataItem = DirectCast(l.NamingContainer, GridDataItem)
l.Text = (DirectCast(container.DataItem, DataRowView))(colname).ToString() + "<br />"
End Sub
End Class
The code sample above results in the following grid:
For more information on creating templates programmatically, see the MSDN article: Creating Web Server Control Templates Programmatically.