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
>