<
script type="text/javascript">
//Uncomment this as well if you use RadAjaxPanel/RadAjaxManager to update any RadControl for ASP.NET AJAX.
// Telerik.Web.UI.RadAjaxControl.prototype._onFormSubmitCompleted = function (sender, args) {
// if (sender._xmlHttpRequest != null) {
// if (this._handleAsyncRedirect(sender._xmlHttpRequest)) {
// try {
// sender._aborted = true;
// }
// catch (e) {
// //
// }
// return;
// }
// }
// if (sender._xmlHttpRequest != null && !sender.get_timedOut()) {
// var scriptBlocks = this.getResponseItems(sender.get_responseData(), "scriptBlock");
// for (var i = 0, length = scriptBlocks.length; i < length; i++) {
// var content = scriptBlocks[i].content;
// if (content.indexOf(Sys.WebForms.PageRequestManager.getInstance()._uniqueIDToClientID(this._uniqueID)) != -1) {
// var linksString = content.substr(content.indexOf("\"links\":") + 10, content.indexOf("]", content.indexOf("\"links\":")) - (content.indexOf("\"links\":") + 10)).replace(/\"/g, '');
// if (linksString != "") {
// this._links = linksString.split(",");
// this.updateHeadLinks();
// }
// }
// if (content.indexOf(".axd") == -1 && scriptBlocks[i].id == "ScriptPath") {
// Telerik.Web.UI.RadAjaxControl.IncludeClientScript(content);
// }
// }
// var panels = this.getResponseItems(sender.get_responseData(), "updatePanel");
// Telerik.Web.UI.RadAjaxControl.panelsToClear = [];
// for (var i = 0, length = panels.length; i < length; i++) {
// var panel = panels[i];
// if (!$get(panel.id)) {
// var newUpdatePanel = document.createElement("div");
// newUpdatePanel.id = panel.id;
// var element = $get(panel.id.replace("Panel", ""));
// if (!element)
// continue;
// var parent = element.parentNode;
// var nextSibling = element.nextSibling || Telerik.Web.UI.RadAjaxControl.GetNodeNextSibling(element);
// if (element.nodeType === 1) {
// if (element.dispose && typeof (element.dispose) === "function") {
// element.dispose();
// }
// else if (element.control && typeof (element.control.dispose) === "function") {
// element.control.dispose();
// }
// var behaviors = Sys.UI.Behavior.getBehaviors(element);
// for (var j = behaviors.length - 1; j >= 0; j--) {
// behaviors[j].dispose();
// }
// }
// $telerik.disposeElement(element);
// parent.removeChild(element);
// Telerik.Web.UI.RadAjaxControl.InsertAtLocation(newUpdatePanel, parent, nextSibling);
// Telerik.Web.UI.RadAjaxControl.panelsToClear[Telerik.Web.UI.RadAjaxControl.panelsToClear.length] = panel;
// }
// }
// }
// sender.get_webRequest().remove_completed(this._onFormSubmitCompletedHandler);
// };
$telerik.disposeElement =
function (element) {
if (typeof (Sys.WebForms) == "undefined")
return;
var prm = Sys.WebForms.PageRequestManager.getInstance();
if (prm && prm._destroyTree)
prm._destroyTree(element);
else if (Sys.Application.disposeElement)
Sys.Application.disposeElement(element,
true);
};
Telerik.Web.UI.RadComboBox.prototype._removeDropDown =
function () {
var slide = this.get_dropDownElement().parentNode;
slide.parentNode.removeChild(slide);
if (this._disposeChildElements)
$telerik.disposeElement(slide);
if (!$telerik.isSafari)
slide.outerHTML =
null;
this._dropDownElement = null;
};
</script>
<telerik:RadGrid ID="radProjectGrid" runat="server" AutoGenerateColumns="false" DataSourceID="entProjectDataSource" |
AllowAutomaticDeletes="true" AllowAutomaticInserts="true" AllowAutomaticUpdates="true" |
Skin="Default" OnItemCommand="radProjectGrid_ItemCommand" |
onitemcreated="radProjectGrid_ItemCreated"> |
<MasterTableView CommandItemDisplay="Top" AutoGenerateColumns="False" DataKeyNames="Project_ID" |
DataSourceID="entProjectDataSource"> |
<RowIndicatorColumn> |
<HeaderStyle Width="20px" /> |
</RowIndicatorColumn> |
<ExpandCollapseColumn> |
<HeaderStyle Width="20px" /> |
</ExpandCollapseColumn> |
<Columns> |
<telerik:GridEditCommandColumn> |
</telerik:GridEditCommandColumn> |
<telerik:GridBoundColumn UniqueName="Project_Title" HeaderText="Project Title" DataField="Project_Title" |
SortExpression="Project_Title"> |
<HeaderStyle Width="150px" HorizontalAlign="Left" VerticalAlign="Middle" Wrap="true" /> |
<ItemStyle Width="150px" HorizontalAlign="Left" VerticalAlign="Middle" Wrap="true" /> |
</telerik:GridBoundColumn> |
<telerik:GridBoundColumn DataField="ProjectLeader_Name" HeaderText="ProjectLeader Name" |
SortExpression="ProjectLeader_Name" UniqueName="ProjectLeader_Name"> |
<HeaderStyle Width="120px" HorizontalAlign="Left" VerticalAlign="Middle" Wrap="true" /> |
<ItemStyle Width="120px" HorizontalAlign="Left" VerticalAlign="Middle" Wrap="true" /> |
</telerik:GridBoundColumn> |
<telerik:GridBoundColumn UniqueName="Location" HeaderText="Location" DataField="Location" |
SortExpression="Location"> |
<HeaderStyle Width="80px" HorizontalAlign="Left" VerticalAlign="Middle" Wrap="true" /> |
<ItemStyle Width="80px" HorizontalAlign="Left" VerticalAlign="Middle" Wrap="true" /> |
</telerik:GridBoundColumn> |
<telerik:GridBoundColumn UniqueName="Start_Date" HeaderText="Start Date" DataField="Start_Date" |
DataType="System.DateTime" SortExpression="Start_Date" DataFormatString="{0:MM/dd/yyyy}"> |
<HeaderStyle Width="80px" HorizontalAlign="Left" VerticalAlign="Middle" Wrap="true" /> |
<ItemStyle Width="80px" HorizontalAlign="Left" VerticalAlign="Middle" Wrap="true" /> |
</telerik:GridBoundColumn> |
<telerik:GridBoundColumn DataField="End_Date" DataType="System.DateTime" HeaderText="End Date" |
SortExpression="End_Date" UniqueName="End_Date" DataFormatString="{0:MM/dd/yyyy}"> |
<HeaderStyle Width="80px" HorizontalAlign="Left" VerticalAlign="Middle" Wrap="true" /> |
<ItemStyle Width="80px" HorizontalAlign="Left" VerticalAlign="Middle" Wrap="true" /> |
</telerik:GridBoundColumn> |
<telerik:GridCheckBoxColumn DataField="IsVisible" DataType="System.Boolean" HeaderText="ShowOnWebsite" |
SortExpression="IsVisible" UniqueName="IsVisible"> |
<HeaderStyle Width="60px" HorizontalAlign="Left" VerticalAlign="Middle" Wrap="true" /> |
<ItemStyle Width="50px" HorizontalAlign="Left" VerticalAlign="Middle" Wrap="true" /> |
</telerik:GridCheckBoxColumn> |
<telerik:GridButtonColumn CommandName="Delete" Text="Delete" UniqueName="column"> |
</telerik:GridButtonColumn> |
</Columns> |
<EditFormSettings EditFormType="Template"> |
<EditColumn UniqueName="EditCommandColumn1"> |
</EditColumn> |
<FormTemplate> |
<div style="float: left"> |
<table> |
<tr> |
<td class="tdLeftAdmin"> |
Project Title: |
</td> |
<td class="tdRightAdmin"> |
<asp:TextBox ID="txtProjectTitle" runat="server" Text='<%# Bind("Project_Title") %>'></asp:TextBox> |
</td> |
</tr> |
<tr> |
<td class="tdLeftAdmin"> |
Location: |
</td> |
<td class="tdRightAdmin"> |
<asp:TextBox ID="txtLocation" runat="server" Text='<%# Bind("Location") %>'></asp:TextBox> |
</td> |
</tr> |
<tr> |
<td class="tdLeftAdmin"> |
Project Leader Name: |
</td> |
<td class="tdRightAdmin"> |
<asp:TextBox ID="txtProjectLeader" runat="server" Text='<%# Bind("ProjectLeader_Name") %>'></asp:TextBox> |
</td> |
</tr> |
<tr> |
<td class="tdLeftAdmin"> |
Start Date: |
</td> |
<td class="tdRightAdmin"> |
<telerik:RadDatePicker ID="rdpStartDate" runat="server" AutoPostBack="false" MinDate="01/01/1000" |
MaxDate="01/01/3000" DbSelectedDate='<%# Bind("Start_Date", "{0:D}") %>' /> |
</td> |
</tr> |
<tr> |
<td class="tdLeftAdmin"> |
End Date: |
</td> |
<td class="tdRightAdmin"> |
<telerik:RadDatePicker ID="rdpEndDate" runat="server" AutoPostBack="false" MinDate="01/01/1000" |
MaxDate="01/01/3000" DbSelectedDate='<%# Bind("End_Date","{0:D}") %>' /> |
</td> |
</tr> |
<tr> |
<td class="tdLeftAdmin"> |
Website: |
</td> |
<td class="tdRightAdmin"> |
<asp:TextBox ID="txtWebsite" runat="server"></asp:TextBox> |
</td> |
</tr> |
<tr> |
<td class="tdLeftAdmin"> |
ShowOnWebsite |
</td> |
<td class="tdRightAdmin"> |
<asp:CheckBox ID="CheckBox1" runat="server" Checked='<%# Bind("IsVisible") %>'/> |
</td> |
</tr> |
<tr> |
<td class="tdLeftAdmin"> |
<asp:Button ID="btnUpdate" runat="server" CommandName='<%# (Container is GridEditFormInsertItem) ? "PerformInsert" : "Update" %>' |
Text='<%# (Container is GridEditFormInsertItem) ? "Insert" : "Update" %>' /> |
</td> |
<td class="tdRightAdmin"> |
<asp:Button ID="btnCancel" runat="server" CausesValidation="False" CommandName="Cancel" |
Text="Cancel" /> |
</td> |
</tr> |
</table> |
</div> |
<div style="width: 450px; float: right;"> |
<table> |
<tr> |
<td class="tdLeftAdmin"> |
Goal: |
</td> |
<td class="tdRightAdmin"> |
<asp:TextBox ID="txtGoal" runat="server" Text='<%# Bind("Goal") %>' TextMode="MultiLine"></asp:TextBox> |
</td> |
</tr> |
<tr> |
<td class="tdLeftAdmin"> |
Objective: |
</td> |
<td class="tdRightAdmin"> |
<asp:TextBox ID="txtObjective" runat="server" Text='<%# Bind("Objective") %>' TextMode="MultiLine"></asp:TextBox> |
</td> |
</tr> |
<tr> |
<td class="tdLeftAdmin"> |
Project Image: |
</td> |
<td class="tdRightAdmin"> |
<telerik:RadUpload ID="radUploadProjectImage" runat="server" ControlObjectsVisibility="None" |
TargetFolder="~/Images"> |
</telerik:RadUpload> |
</td> |
</tr> |
<tr> |
<td class="tdLeftAdmin"> |
Leader Image: |
</td> |
<td class="tdRightAdmin"> |
<telerik:RadUpload ID="radUploadProjectLeaderImage" runat="server" ControlObjectsVisibility="None" |
TargetFolder="~/Images"> |
</telerik:RadUpload> |
</td> |
</tr> |
</table> |
</div> |
</FormTemplate> |
</EditFormSettings> |
</MasterTableView> |
<ClientSettings> |
<ClientEvents OnRowDblClick="RowDblClick" /> |
</ClientSettings> |
</telerik:RadGrid> |
I am using RadScheduler, but I have a little bit unusual requirements. Couple things I need to do:
Thank you
Dim dbConn As String = [get conn string]
Dim query As String = ""
Dim selectClause As String = "SELECT ID, AccountType "
Dim fromClause As String = "FROM tbl_WIP_DATA_AccountTypes WITH (NOLOCK) "
Dim whereClause As String = "WHERE Active=1 AND Deleted=0"
If FilterExpression <> "" Then FilterExpression = " AND AccountType LIKE '%" & CleanForSQL(FilterExpression) & "%'"
whereClause &= " " & filterExpression
query = selectClause & " " & fromClause & " " & whereClause & " ORDER BY AccountType ASC"
Return WIP.Data.SqlHelper.ExecuteDataset(dbConn, CommandType.Text, query).Tables(0).DefaultView
Now this works fine! Paging etc works as it should. As you can see, it's dynamic t-sql.
BUT, if the getSizes() functions calls a second function get build a generic sql statement (based on a metadata system),
Radgrid displays the records correctly, but refuses to page.
I've tested the resulting queries and they are identical.
Does anyone have any suggestions why this would not work?!
Cheers in advance,
Rich
<%@ Page Language="vb" AutoEventWireup="false" CodeBehind="WebForm1.aspx.vb" Inherits="WebApplication4.WebForm1" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<
html
xmlns
=
"http://www.w3.org/1999/xhtml"
>
<
head
runat
=
"server"
>
<
title
></
title
>
<
script
runat
=
"server"
>
Sub rg_NeedDataSource(ByVal sender As Object, ByVal e As Telerik.Web.UI.GridNeedDataSourceEventArgs) Handles rg.NeedDataSource
Dim dt As New System.Data.DataTable()
dt.Columns.Add("Col1", GetType(String))
dt.Columns.Add("Col2", GetType(String))
For i As Integer = 0 To 10
dt.Rows.Add({"Row" & i, "Data"})
Next
rg.DataSource = dt
End Sub
</
script
>
<
script
type
=
"text/javascript"
>
function callWebService()
{
$telerik.$.ajax({
type: 'POST',
url: 'WebService1.asmx/HelloWorld',
contentType: 'application/json; charset=utf-8',
dataType: 'json'
});
}
</
script
>
</
head
>
<
body
>
<
form
id
=
"form1"
runat
=
"server"
>
<
asp:ScriptManager
ID
=
"ScriptManager"
runat
=
"server"
>
</
asp:ScriptManager
>
<
div
>
<
telerik:RadGrid
ID
=
"rg"
runat
=
"server"
AutoGenerateColumns
=
"true"
Width
=
"100%"
>
<
ClientSettings
>
<
Scrolling
AllowScroll
=
"true"
ScrollHeight
=
"281px"
UseStaticHeaders
=
"true"
/>
</
ClientSettings
>
</
telerik:RadGrid
>
<
asp:Button
ID
=
"aaa"
runat
=
"server"
Text
=
"callWebService"
OnClientClick
=
"callWebService(); return false;"
/>
</
div
>
</
form
>
</
body
>
</
html
>
Imports System.Web.Services
Imports System.Web.Services.Protocols
Imports System.ComponentModel
<
System.Web.Script.Services.ScriptService
()>
Public Class WebService1
Inherits System.Web.Services.WebService
<
WebMethod
()> _
Public Function HelloWorld() As String
Return "Hello World"
End Function
End Class
<
system.webServer
>
<
modules
runAllManagedModulesForAllRequests
=
"true"
>
<
remove
name
=
"RadCompression"
/>
<
add
name
=
"RadCompression"
preCondition
=
"managedHandler"
type
=
"Telerik.Web.UI.RadCompression"
/>
</
modules
>
</
system.webServer
>
<
telerik:GridBoundColumn
SortExpression
=
"ClientName"
DataField
=
"ClientName"
HeaderText
=
"Client Name"
>
<
FilterTemplate
>
<
telerik:RadComboBox
ID
=
"RadComboBoxClientName"
DataTextField
=
"ClientName"
DataValueField
=
"ClientName"
AppendDataBoundItems
=
"true"
Width
=
"150px"
SelectedValue='<%# ((GridItem)Container).OwnerTableView.GetColumn("ClientName").CurrentFilterValue %>' runat="server" OnClientSelectedIndexChanged="ClientNameIndexChanged" Skin="Office2007">
</
telerik:RadComboBox
>
<
telerik:RadScriptBlock
ID
=
"RadScriptBlock1"
runat
=
"server"
>
<
script
type
=
"text/javascript"
>
function ClientNameIndexChanged(sender, args) {
var tableView = $find("<%# ((GridItem)Container).OwnerTableView.ClientID %>");
if (args.get_item().get_value() == "0") {
tableView.filter("ClientName", args.get_item().get_value(), "NoFilter");
}
else {
tableView.filter("ClientName", args.get_item().get_value(), "EqualTo");
}
}
</
script
>
</
telerik:RadScriptBlock
>
</
FilterTemplate
>
<
ItemStyle
VerticalAlign
=
"Top"
/>
</
telerik:GridBoundColumn
>