server side to client side column binding code

[Swapnil]

this is my code , i want to this from design side not code behind

<telerik:RadGrid ID="RadGridEmployeeCost" runat="server" AllowSorting="True" AllowPaging="true"
    AllowFilteringByColumn="true" CellSpacing="0" GridLines="None" HeaderStyle-Font-Bold="true"
    Skin="Web20" OnNeedDataSource="RadGridEmployeeCost_NeedDataSource" ShowGroupPanel="true"
    OnColumnCreated="RadGridEmployeeCost_ColumnCreated">
    <ClientSettings AllowDragToGroup="True" />
</telerik:RadGrid>

protected void RadGridEmployeeCost_NeedDataSource(object sender, GridNeedDataSourceEventArgs e)
       {
               ObjCon.Open();
               SqlCommand ObjCmd = new SqlCommand("SELECT name,address,TelPhone,EmailId,Qualification FROM WorkSummary", ObjCon);
               ObjCmd.ExecuteNonQuery();
               SqlDataAdapter ObjDa = new SqlDataAdapter(ObjCmd);
               DataSet ds = new DataSet();
               ObjDa.Fill(ds);
               RadGridEmployeeCost.DataSource = ds;
           }
       }

protected void RadGridEmployeeCost_ColumnCreated(object sender, GridColumnCreatedEventArgs e)
       {
           if ((e.Column is GridBoundColumn && e.Column.UniqueName == "TelPhone" || e.Column.UniqueName == "EmailId" || e.Column.UniqueName == "Qualification"))
           {
               GridBoundColumn column = e.Column as GridBoundColumn;
               column.AllowFiltering = false;
           }
       }

share the code to do this
thanks

[Shinu]

Hi Swapnil,

You can try the Declarative DataSource to bind from the design side. Check here for all the Data Source Controls that you can use.
Then for your second case, to cancel filtering for columns you can set AllowFiltering="false" for that bound column.

ASPX:

<asp:SqlDataSource ID="sdsGridDetails" runat="server" ConnectionString="<%$ ConnectionStrings:ConnectionString %>"
SelectCommand="SELECT name,address,TelPhone,EmailId,Qualification FROM WorkSummary"></asp:SqlDataSource>


<telerik:GridBoundColumn UniqueName="EmailId" DataField="EmailId" HeaderText="EmailId" AllowFiltering="false">
</telerik:GridBoundColumn>

Thanks,
Shinu