[Solved] how to implement filtering pagind and editing on telerik grid into mvc application

[vikas gupta]

i am using telerik grid into mbn\vc application.i able to bind telerik grid with database and implement sorting on it.

now i want to implement filtering,Paging and editing on that Grid. how can i implement these functionality on the Telerik Grid..

My code is like this:

Controller code

  public ActionResult Index()
        {
            SqlConnection con=new SqlConnection(ConfigurationManager.ConnectionStrings["cn"].ConnectionString);
            SqlDataAdapter adp = new SqlDataAdapter("select * from tbltestMvc", con);
            DataTable dt = new DataTable();
            adp.Fill(dt);
            ArrayList arr = new ArrayList();
            ViewData["Customers"] = dt;
            return View();
        }

Index aspx page code:

 <telerik:RadScriptManager ID="RadScriptManager1" runat="server">
</telerik:RadScriptManager>

<%
    radgrid1.DataSource = ViewData["Customers"];
    radgrid1.DataBind();
%>
  <telerik:RadGrid AutoGenerateColumns="false" ID="radgrid1" runat="server"  AllowSorting="true" >
  <MasterTableView>
       <Columns>
           <telerik:GridBoundColumn DataField="ContactTitle" HeaderText="Title" />
           <telerik:GridBoundColumn DataField="ContactName"  HeaderText="Name" />
           <telerik:GridBoundColumn DataField="Country" HeaderText="Country" />
       </Columns>
   </MasterTableView>
  
  </telerik:RadGrid>
    <telerik:RadDatePicker ID="RadDatePicker1" Runat="server">
    </telerik:RadDatePicker>
    <telerik:RadDateTimePicker ID="RadDateTimePicker1" Runat="server">
    </telerik:RadDateTimePicker>

Thanks