RadWindow window = new RadWindow();window.ID = "windowShowPrintDialog";//window.NavigateUrl = "PrintAdHoc.aspx";window.VisibleOnPageLoad = true;window.Modal = true;window.Width = 200;window.Height = 300;string jsPrint = null;using (StreamReader sr = new StreamReader(Server.MapPath("PrintWindowJavaScript.txt"))){ jsPrint = sr.ReadToEnd();}window.ContentContainer.Controls.Add(new LiteralControl(jsPrint));...
window.ContentContainer.Controls.Add(new LiteralControl(name));window.ContentContainer.Controls.Add(new LiteralControl(startdate));window.ContentContainer.Controls.Add(new LiteralControl(enddate));window.ContentContainer.Controls.Add(new LiteralControl("<button onclick=\"printWin(); return false\">print content</button><br />"));<script type="text/javascript">function GetRadWindow(){ var oWindow = null; if (window.radWindow) oWindow = window.radWindow; else if (window.frameElement.radWindow) oWindow = window.frameElement.radWindow; return oWindow;} function printWin() { var oWnd = GetRadWindow(); var content = oWnd.GetContentFrame().contentWindow; var printDocument = content.document; if (document.all) { printDocument.execCommand( "Print"); } else { content.print(); } } </script>this.Form1.Controls.Add(window);

<
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
