Posted 17 Jan 2014 Link to this post
<
telerik:RadAjaxManager
ID
=
"RadAjaxManager1"
runat
"server"
>
AjaxSettings
telerik:AjaxSetting
AjaxControlID
"RadGrid1"
UpdatedControls
telerik:AjaxUpdatedControl
ControlID
LoadingPanelID
"RadAjaxLoadingPanel1"
/>
</
telerik:RadAjaxLoadingPanel
Posted 20 Jan 2014 Link to this post
UpdateInitiatorPanelsOnly
"true"
EnableAJAX
"Panel1"
asp:Panel
telerik:RadGrid
PageSize
"20"
AllowSorting
"True"
AllowPaging
OnPageIndexChanged
"RadGrid1_PageIndexChanged"
AutoGenerateColumns
"False"
MasterTableView
Columns
telerik:GridBoundColumn
DataField
"OrderID"
HeaderText
"OrderDate"
protected
void
Page_Load(
object
sender, EventArgs e)
{
if
(!IsPostBack)
RadGrid1.DataSource = LoadData(
"SELECT OrderID,OrderDate FROM Orders"
);
RadGrid1.DataBind();
}
RadGrid1_PageIndexChanged(
source, Telerik.Web.UI.GridPageChangedEventArgs e)
RadGrid1.CurrentPageIndex = e.NewPageIndex;
RadGrid1.DataSource=LoadData(
public
DataTable LoadData(
string
query)
String ConnString = ConfigurationManager.ConnectionStrings[
"Northwind_newConnectionString3"
].ConnectionString;
SqlConnection conn =
new
SqlConnection(ConnString);
SqlDataAdapter adapter =
SqlDataAdapter();
adapter.SelectCommand =
SqlCommand(query, conn);
DataTable myDataTable =
DataTable();
conn.Open();
try
adapter.Fill(myDataTable);
finally
conn.Close();
return
myDataTable;