or
<telerik:RadGrid runat="server" ID="RadGrid2" AllowPaging="True" AllowSorting="true" OnNeedDataSource="RadGrid2_NeedDataSource" AllowFilteringByColumn="True" Skin="Sunset"> <ClientSettings> <Scrolling AllowScroll="True" UseStaticHeaders="True"></Scrolling> </ClientSettings> </telerik:RadGrid>protected void RadGrid2_NeedDataSource(object sender, Telerik.Web.UI.GridNeedDataSourceEventArgs e) { (sender as RadGrid).DataSource = GetDataTable(); } public DataTable GetDataTable() { string str1 = (string)(Session["UserName"]); string query = "select Acer_Status,No_Of_Vouchers,Acer_Actual_Balance ,Zero_To_Thirty_Days , Thirtyone_To_Sixty_Days ,Sixtyone_To_Ninety_Days ,Ninetyone_Days_Plus from ACER_AR_SUMMARY1 where Practice_Short_Name ='" + str1 + "'"; String ConnString = ConfigurationManager.ConnectionStrings["conn"].ConnectionString; SqlConnection conn = new SqlConnection(ConnString); SqlDataAdapter adapter = new SqlDataAdapter(); adapter.SelectCommand = new SqlCommand(query, conn); DataTable myDataTable = new DataTable(); conn.Open(); try { adapter.Fill(myDataTable); } finally { conn.Close(); } return myDataTable; }<modules runAllManagedModulesForAllRequests="true"> <add name="MyModule" type="MyModule" /></modules><httpHandlers><add path="Telerik.Web.UI.WebResource.axd" type="Telerik.Web.UI.WebResourceSession, Telerik.Web.UI" verb="*" validate="false" /></httpHandlers><handlers><add name="Telerik_Web_UI_WebResource_axd" verb="*" preCondition="integratedMode" path="Telerik.Web.UI.WebResource.axd" type="Telerik.Web.UI.WebResourceSession, Telerik.Web.UI" /></handlers>