Hi,

I'm new to RadGrid so sorry if this is a silly question.

I have an application where I am adding 'custom columns' to a DataGrid. My custom column is a class i have created that derives from TemplateField.

I now need to freeze the first column of the DataGrid so i am trying to migrate from a standard gridview to a RadGrid.

My question is how can I programmatically add TemplateFields to a RadGrid?

Example code from my application:

// custom class that represents a column in a GridView
public class CustomColumnTemplate : TemplateField{ // code removed for brevity }

// custom class that represents the ItemTemplate for CustomColumnTemplate
public class BaseSetOfValuesColumn : ITemplate{ // code removed for brevity }

//  code to add custom columns to GridView
CustomColumnTemplate sovCol = new CustomColumnTemplate();
sovCol .ItemTemplate = new SetofValuesColumn();
myGridView.Columns.Add(sovCol);

Protected Sub ItemsRequested(ByVal o As Object, ByVal e As RadComboBoxItemsRequestedEventArgs) Handles RCBClient.ItemsRequested

Try

Dim selectCommand As New SqlCommand("GetClients", myConnection)

selectCommand.CommandType = CommandType.StoredProcedure

selectCommand.Parameters.AddWithValue(

"@CN", e.Text)

Dim adapter As New SqlDataAdapter(selectCommand)

Dim DT As New DataTable()

adapter.Fill(DT)

RCBClient.DataTextField =

"Client"

"ClientID"

Catch

End Try

End Sub

Protected Sub btnLoad_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles btnLoad.Click

Using selectCommand As New SqlCommand("CreateClient", myConnection)

selectCommand.CommandType = CommandType.StoredProcedure

selectCommand.Parameters.AddWithValue(

"@CN", RCBClient.Text)

myConnection.Open()

Using reader As SqlDataReader = selectCommand.ExecuteReader

While reader.Read

Build_CustomerRep(reader(

"CID"))

Build_Facility(reader(

"CID"))

End While

End Using

End Using

End Sub

.aspx

<tr><td>Client:</td>

<td><Telerik:RadComboBox ID="RCBClient" EnableEmbeddedSkins="false" Skin="Default" runat="server" ShowMoreResultsBox="False" EnableLoadOnDemand="True" OnItemsRequested="ItemsRequested" AutoPostBack="true" >

<CollapseAnimation Type="OutExpo" Duration="200"></CollapseAnimation>

</Telerik:RadComboBox>

</td>

<td><asp:Button runat="server" ID="btnLoad" Text="Create New" /></td>

</tr>

Error:

 

Server Error in '/' Application.

---

Input string was not in a correct format.

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.FormatException: Input string was not in a correct format.

Source Error:

[FormatException: Input string was not in a correct format.]
   Microsoft.VisualBasic.CompilerServices.Conversions.ParseDouble(String Value, NumberFormatInfo NumberFormat) +717374
   Microsoft.VisualBasic.CompilerServices.Conversions.ToInteger(String Value) +118

[InvalidCastException: Conversion from string "" to type 'Integer' is not valid.]
   Microsoft.VisualBasic.CompilerServices.Conversions.ToInteger(String Value) +721303
   Mistras_Admin_ClientSetup.RCBClient_SelectedIndexChanged(Object o, RadComboBoxSelectedIndexChangedEventArgs e) +87
   Telerik.Web.UI.RadComboBox.OnSelectedIndexChanged() +183
   System.Web.UI.Page.RaiseChangedEvents() +89
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +2777

Version Information: Microsoft .NET Framework Version:2.0.50727.3074; ASP.NET Version:2.0.50727.3074