<form id="form1" runat="server">
<asp:ScriptManager ID="ScriptManager1" runat="server" />
<telerik:RadAjaxManager runat="server" ID="RadAjaxManager1">
<AjaxSettings>
<telerik:AjaxSetting AjaxControlID="RadGrid1">
<UpdatedControls>
<telerik:AjaxUpdatedControl ControlID="RadGrid1" />
</UpdatedControls>
</telerik:AjaxSetting>
</AjaxSettings>
</telerik:RadAjaxManager>
<div>
<telerik:RadGrid ID="RadGrid1" runat="server" DataSourceID="SqlDataSource1" GridLines="None"
AutoGenerateEditColumn="true" AllowMultiRowEdit="true" AllowMultiRowSelection="true"
PagerStyle-Mode="NextPrevAndNumeric">
<MasterTableView AutoGenerateColumns="True" DataSourceID="SqlDataSource1" DataKeyNames="CategoryID"
Name="MasterTableView" CommandItemDisplay="Top" PageSize="3" AllowPaging="true">
<CommandItemTemplate>
<asp:LinkButton Style="vertical-align: bottom" ID="btnEditSelected1" runat="server"
CommandName="EditSelected" CausesValidation="false" Visible='<%# RadGrid1.EditIndexes.Count == 0 %>'><img style="border:0px;vertical-align:middle;" alt="" src="../Include/Images/Edit.gif" /> Edit Selected Records</asp:LinkButton>
<asp:LinkButton ID="btnCancel1" runat="server" CommandName="CancelAll" CausesValidation="false"
Visible='<%# (RadGrid1.EditIndexes.Count > 0 || RadGrid1.MasterTableView.IsItemInserted) %>'><img style="border:0px;vertical-align:middle;" alt="" src="../Include/Images/Cancel.gif" /> Cancel editing</asp:LinkButton>
</CommandItemTemplate>
<DetailTables>
<telerik:GridTableView DataKeyNames="CategoryID" AutoGenerateColumns="true" DataSourceID="SqlDataSource2"
CommandItemDisplay="Top" AllowPaging="true" PageSize="3">
<CommandItemTemplate>
<asp:LinkButton Style="vertical-align: bottom" ID="btnEditSelected" runat="server"
CommandName="EditSelected" CausesValidation="false" Visible='<%# RadGrid1.EditIndexes.Count == 0 %>'><img style="border:0px;vertical-align:middle;" alt="" src="../Include/Images/Edit.gif" /> Edit Selected Records</asp:LinkButton>
<asp:LinkButton ID="btnCancel" runat="server" CommandName="CancelAll" CausesValidation="false"
Visible='<%# (RadGrid1.EditIndexes.Count > 0 || RadGrid1.MasterTableView.IsItemInserted) %>'><img style="border:0px;vertical-align:middle;" alt="" src="../Include/Images/Cancel.gif" /> Cancel editing</asp:LinkButton>
</CommandItemTemplate>
<ParentTableRelation>
<telerik:GridRelationFields DetailKeyField="CategoryID" MasterKeyField="CategoryID" />
</ParentTableRelation>
</telerik:GridTableView>
</DetailTables>
</MasterTableView>
<ClientSettings>
<Selecting AllowRowSelect="true" />
</ClientSettings>
</telerik:RadGrid>
<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:NorthwindConnectionString %>"
SelectCommand="SELECT * FROM [Categories]"></asp:SqlDataSource>
<asp:SqlDataSource ID="SqlDataSource2" runat="server" ConnectionString="<%$ ConnectionStrings:NorthwindConnectionString %>"
SelectCommand="SELECT * FROM [Products] WHERE ([CategoryID] = @CategoryID)">
<SelectParameters>
<asp:Parameter Name="CategoryID" Type="Int32" />
</SelectParameters>
</asp:SqlDataSource>
</div>
</form>
Thank you for your time.
I have SQL Server 2005 (Standard Ver) installed on my Windows XP computer. As this version does not allow attaching a new database file from the application code (as does the Express ver), apparently I need first to attach these databases manually and then use them. Here are my questions:
Tariq
| <%@ Control Language="C#" AutoEventWireup="true" CodeFile="ImageNewsVideo.ascx.cs" Inherits="ImageCaller" %> |
| <%@ Register Assembly="Telerik.Web.UI" Namespace="Telerik.Web.UI" TagPrefix="telerik" %> |
| <script type="text/javascript"> |
| var currentTextBoxID; |
| function ImageManagerFunction(sender, args) |
| { |
| var selectedItem = args.SelectedItem; |
| var resultImageObject = args.Result; |
| var txt = $get(currentTextBoxID); |
| txt.value = selectedItem.getPath(); |
| } |
| </script> |
| <asp:TextBox ID="LinkImage" runat="server"></asp:TextBox> |
| <telerik:dialogopener runat="server" id="DialogOpener1" > |
| </telerik:dialogopener> |
| <button onclick="currentTextBoxID='<%= LinkImage.ClientID %>';$find('<%= DialogOpener1.ClientID %>').open('DocumentManager');return false;">Select</button> |
| protected void Page_Load(object sender, EventArgs e) |
| { |
| // set the view path dinamically to this path |
| FileManagerDialogParameters dialogParameters1 = new FileManagerDialogParameters(); |
| dialogParameters1.ViewPaths = new string[] { "~/contents/infoVideos/" }; |
| dialogParameters1.UploadPaths = new string[] { "~/contents/infoVideos/" }; |
| dialogParameters1.DeletePaths = new string[] { "~/contents/infoVideos/" }; |
| dialogParameters1.MaxUploadFileSize = 5000000; |
| dialogParameters1.SearchPatterns = new string[] { "*.*" };//{"*.avi,*.wmf,*.flv"}; |
| DialogDefinition DocumentManager = new DialogDefinition(typeof(DocumentManagerDialog), dialogParameters1); |
| DocumentManager.ClientCallbackFunction = "DocumentManagerFunction"; |
| DocumentManager.Width = Unit.Pixel(694); |
| DocumentManager.Height = Unit.Pixel(440); |
| DialogOpener1.DialogDefinitions.Add("DocumentManager", DocumentManager); |
| } |

function
RowContextMenu(sender, eventArgs)
{
var cellIndex = eventArgs.get_domEvent().target.cellIndex;
var colName = eventArgs.get_tableView().get_columns()[cellIndex].get_uniqueName();
So in the above i get the physical cell index rather than the one which factors that there are hidden columns before that. Is there anyway around this.
| <script type="text/javascript" language="javascript"> |
| function GetRadWindow() |
| { |
| var oWindow = null; |
| if (window.radWindow) |
| oWindow = window.radWindow; |
| else if (window.frameElement.radWindow) |
| oWindow = window.frameElement.radWindow; |
| return oWindow; |
| } |
| function cancelWindow() |
| { |
| var oWindow = GetRadWindow(); |
| oWindow.argument = null; |
| oWindow.close(); |
| } |
| function closeClientCallBack() |
| { |
| var currentWindow = GetRadWindow(); |
| var Input = document.getElementById("ddlDocument"); |
| currentWindow.argument = null; |
| currentWindow.close(Input.value); |
| RefreshParentPage(); |
| } |
| function clientClose() |
| { |
| var currentWindow = GetRadWindow(); |
| var Input = document.getElementById("ddlDocument"); |
| currentWindow.argument = Input.innerText; |
| currentWindow.close(); |
| RefreshParentPage(); |
| } |
| function RefreshParentPage() |
| { |
| GetRadWindow().BrowserWindow.location.href = GetRadWindow().BrowserWindow.location.href; |
| } |
| </script> |
| <asp:Button |
| ID="btnOpenDocument" |
| runat="server" |
| OnClientClick="closeClientCallBack();return false;" |
| AlternateText="Open Document" |
| Text="Open"> |
| </asp:Button> |
| <asp:Button |
| ID="btnCancelOpenDocument" |
| runat="server" |
| OnClientClick="cancelWindow();return false;" |
| Text="Cancel"> |
| </asp:Button> |
<
asp:Label ID="LblContactID" runat="server" Visible="False"></asp:Label><asp:Label ID="LblError" runat="server"></asp:Label><br />
<
asp:Panel ID="Panel1" runat="server" Width="100%" GroupingText="Customer Account List">
<radA:AjaxLoadingPanel ID="AjaxLoadingCustAccts" runat="server" Height="75px" Width="75px">
<asp:Image ID="Image2" runat="server" AlternateText="Loading..." ImageUrl="~/RadControls/Ajax/Skins/Default/Loading.gif" />
</radA:AjaxLoadingPanel>
<
radG:RadGrid ID="GrdCustomerList" runat="server" AllowPaging="True" AllowSorting="True" AutoGenerateColumns="False" EnableAJAX="True" Skin="Green" Width="600px" EnableAJAXLoadingTemplate="True" GridLines="None" Title="Available Customer Accounts">
<MasterTableView DataKeyNames="ID" GridLines="Both" BorderColor="Black" Caption="Available Customer Accounts">
<Columns>
<radG:GridButtonColumn ButtonType="PushButton" CommandName="Select" HeaderText="Set Default"
Text=">>" UniqueName="column" ImageUrl="~/Images/eNora2/SetDefault.gif">
<HeaderStyle Font-Bold="True" Font-Italic="False" Font-Overline="False" Font-Strikeout="False"
Font-Underline="True" HorizontalAlign="Center" Width="75px" Wrap="True" />
<ItemStyle Font-Bold="False" Font-Italic="False" Font-Overline="False" Font-Strikeout="False"
Font-Underline="False" HorizontalAlign="Center" Wrap="True" />
</radG:GridButtonColumn>
<radG:GridBoundColumn DataField="ID" HeaderText="Account GUID" UniqueName="Account GUID" Visible="False">
</radG:GridBoundColumn>
<radG:GridTemplateColumn HeaderText="Select" UniqueName="Select">
<ItemTemplate>
<asp:CheckBox ID="CbxSelect" runat="server" />
</ItemTemplate>
<HeaderStyle Font-Bold="True" Font-Italic="False" Font-Overline="False" Font-Strikeout="False"
Font-Underline="True" HorizontalAlign="Center" Width="50px" Wrap="True" />
<ItemStyle Font-Bold="False" Font-Italic="False" Font-Overline="False" Font-Strikeout="False"
Font-Underline="False" HorizontalAlign="Center" Wrap="True" />
<HeaderTemplate>
<strong><span style="font-size: 10pt; font-family: Arial">Select<br />
</span></strong>
<input id="btnCheckAll" style="width: 74px; height: 23px" type="button" value="Select All" language="javascript" onclick="return btnCheckAll_onclick()" />
</HeaderTemplate>
</radG:GridTemplateColumn>
<radG:GridBoundColumn HeaderText="Account Name" UniqueName="Branch" DataField="Branch">
<HeaderStyle Font-Bold="False" Font-Italic="False" Font-Overline="False" Font-Strikeout="False"
Font-Underline="False" HorizontalAlign="Center" Width="150px" Wrap="True" />
<ItemStyle Font-Bold="False" Font-Italic="False" Font-Overline="False" Font-Strikeout="False"
Font-Underline="False" HorizontalAlign="Center" Wrap="True" />
</radG:GridBoundColumn>
<radG:GridBoundColumn HeaderText="Division" UniqueName="CBU" DataField="CBU">
<HeaderStyle Font-Bold="False" Font-Italic="False" Font-Overline="False" Font-Strikeout="False"
Font-Underline="False" HorizontalAlign="Center" Width="75px" Wrap="True" />
<ItemStyle Font-Bold="False" Font-Italic="False" Font-Overline="False" Font-Strikeout="False"
Font-Underline="False" HorizontalAlign="Center" Wrap="True" />
</radG:GridBoundColumn>
<radG:GridBoundColumn HeaderText="Brand" UniqueName="Brand" DataField="Brand">
<HeaderStyle Font-Bold="False" Font-Italic="False" Font-Overline="False" Font-Strikeout="False"
Font-Underline="False" HorizontalAlign="Center" Width="75px" Wrap="True" />
<ItemStyle Font-Bold="False" Font-Italic="False" Font-Overline="False" Font-Strikeout="False"
Font-Underline="False" HorizontalAlign="Center" Wrap="True" />
</radG:GridBoundColumn>
<radG:GridBoundColumn HeaderText="City" UniqueName="City" DataField="City">
<HeaderStyle Font-Bold="False" Font-Italic="False" Font-Overline="False" Font-Strikeout="False"
Font-Underline="False" HorizontalAlign="Center" Width="75px" Wrap="True" />
<ItemStyle Font-Bold="False" Font-Italic="False" Font-Overline="False" Font-Strikeout="False"
Font-Underline="False" HorizontalAlign="Center" Wrap="True" />
</radG:GridBoundColumn>
<radG:GridBoundColumn HeaderText="State" UniqueName="State" DataField="State">
<HeaderStyle Font-Bold="False" Font-Italic="False" Font-Overline="False" Font-Strikeout="False"
Font-Underline="False" HorizontalAlign="Center" Width="60px" Wrap="True" />
<ItemStyle Font-Bold="False" Font-Italic="False" Font-Overline="False" Font-Strikeout="False"
Font-Underline="False" HorizontalAlign="Center" Wrap="True" Width="30px" />
</radG:GridBoundColumn>
<radG:GridBoundColumn DataField="Zip" HeaderText="Zip" UniqueName="Zip">
<HeaderStyle Font-Bold="False" Font-Italic="False" Font-Overline="False" Font-Strikeout="False"
Font-Underline="False" HorizontalAlign="Center" Width="75px" Wrap="True" />
<ItemStyle Font-Bold="False" Font-Italic="False" Font-Overline="False" Font-Strikeout="False"
Font-Underline="False" HorizontalAlign="Center" Wrap="True" Width="40px" />
</radG:GridBoundColumn>
<radG:GridBoundColumn DataField="BrandId" HeaderText="BrandID" UniqueName="BrandId" Visible="False">
</radG:GridBoundColumn>
<radG:GridBoundColumn DataField="CbuId" HeaderText="CbuId" UniqueName="CbuId" Visible="False">
</radG:GridBoundColumn>
<radG:GridBoundColumn DataField="BranchId" HeaderText="BranchId" UniqueName="BranchId" Visible="False">
</radG:GridBoundColumn>
</Columns>
<ExpandCollapseColumn Visible="False">
<HeaderStyle Width="19px" />
</ExpandCollapseColumn>
<RowIndicatorColumn Visible="False">
<HeaderStyle Width="20px" />
</RowIndicatorColumn>
<PagerStyle Mode="NextPrevAndNumeric" />
</MasterTableView>
<SelectedItemStyle BackColor="DarkGray" BorderStyle="Ridge" BorderWidth="1px" ForeColor="Red" Font-Bold="True" />
<PagerStyle ForeColor="White" />
</
radG:RadGrid></asp:Panel>
<asp:Button ID="BtnAddSelected" runat="server" Text="Add Selected Accounts" /><br />
<
asp:Panel ID="Panel2" runat="server" Width="100%" GroupingText="Selected Account List"><table Width="600">
<tr>
<td style="height: 21px; text-align: right" colspan="5">
User Accounts Per Page:
<asp:DropDownList ID="ddlAccountCount" runat="server" AutoPostBack="True">
<asp:ListItem>10</asp:ListItem>
<asp:ListItem Selected="True">25</asp:ListItem>
<asp:ListItem>50</asp:ListItem>
<asp:ListItem>100</asp:ListItem>
<asp:ListItem>All</asp:ListItem>
</asp:DropDownList></td>
</tr>
</
table>
<radA:AjaxLoadingPanel ID="AjaxLoadingSelectedAccts" runat="server" Height="75px"
Width="75px">
<asp:Image ID="Image1" runat="server" AlternateText="Loading..." ImageUrl="~/RadControls/Ajax/Skins/Default/Loading.gif" />
</radA:AjaxLoadingPanel>
<
radG:RadGrid ID="GrdSelectedCustomers" runat="server" AutoGenerateColumns="False"
Description="Selected Customer Accounts" Title="Selected Customer Accounts" Width="600px" EnableAJAX="True" GridLines="None" AllowPaging="True" EnableAJAXLoadingTemplate="True" Skin="Green">
<MasterTableView Caption="Selected Customer Account" DataKeyNames="ID">
<RowIndicatorColumn Visible="False">
<HeaderStyle Width="20px" />
</RowIndicatorColumn>
<ExpandCollapseColumn Visible="False">
<HeaderStyle Width="19px" />
</ExpandCollapseColumn>
<Columns>
<radG:GridButtonColumn ButtonType="PushButton" CommandName="Select" HeaderText="Set Default"
Text=" >> " UniqueName="column">
</radG:GridButtonColumn>
<radG:GridBoundColumn HeaderText="Account GUID" UniqueName="Account GUID" DataField="ID" Visible="False">
</radG:GridBoundColumn>
<radG:GridBoundColumn HeaderText="Account Name" UniqueName="column" DataField="Branch">
</radG:GridBoundColumn>
<radG:GridBoundColumn HeaderText="Division" UniqueName="column" DataField="CBU">
</radG:GridBoundColumn>
<radG:GridBoundColumn HeaderText="Brand" UniqueName="column" DataField="Brand">
</radG:GridBoundColumn>
<radG:GridBoundColumn HeaderText="City" UniqueName="column" DataField="City">
</radG:GridBoundColumn>
<radG:GridBoundColumn HeaderText="State" UniqueName="column" DataField="State">
</radG:GridBoundColumn>
<radG:GridBoundColumn HeaderText="Zip" UniqueName="column" DataField="Zip">
</radG:GridBoundColumn>
<radG:GridButtonColumn ButtonType="PushButton" CommandName="Delete" HeaderText="Remove"
Text=" X " UniqueName="column">
</radG:GridButtonColumn>
</Columns>
</MasterTableView>
</
radG:RadGrid></asp:Panel>
<
radA:RadAjaxManager ID="RadAjaxManager1" runat="server">
<AjaxSettings>
<radA:AjaxSetting AjaxControlID="BtnAddSelected">
<UpdatedControls>
<radA:AjaxUpdatedControl ControlID="Panel1" LoadingPanelID="AjaxLoadingCustAccts" />
<radA:AjaxUpdatedControl ControlID="Panel2" LoadingPanelID="AjaxLoadingSelectedAccts" />
</UpdatedControls>
</radA:AjaxSetting>
</AjaxSettings>
</
radA:RadAjaxManager>
| <telerik:RadTabStrip ID="RadTabStrip1" SelectedIndex="0" runat="server" |
| MultiPageID="RadMultiPage1" Skin="WebBlue" CausesValidation="False" > |
| <Tabs> |
| <telerik:RadTab runat="server" Text="Notes" PageViewID="PageView1" |
| Selected="True"> |
| </telerik:RadTab> |
| <telerik:RadTab runat="server" Text="Rider" PageViewID="PageView2" > |
| </telerik:RadTab> |
| <telerik:RadTab runat="server" Text="Biography" PageViewID="PageView3" > |
| </telerik:RadTab> |
| </Tabs> |
| </telerik:RadTabStrip> |
| <telerik:RadMultiPage id="RadMultiPage1" runat="server" SelectedIndex="1"> |
| <telerik:RadPageView id="Pageview1" runat="server"> |
| |
| |
| <rad:RadTextBox ID="RadTextBoxArtistNotes" runat="server" Height="410px" |
| Skin="Web20" Width="550px"></rad:RadTextBox> |
| |
| |
| </telerik:RadPageView> |
| <telerik:RadPageView id="Pageview2" runat="server"> |
| |
| |
| <rad:RadTextBox ID="RadTextBoxArtistRider" runat="server" Height="410px" |
| Skin="Web20" Width="550px"></rad:RadTextBox> |
| |
| |
| </telerik:RadPageView> |
| <telerik:RadPageView id="RadPageView3" runat="server"> |
| |
| |
| |
| |
| <telerik:RadEditor ID="RadEditorBiography" Runat="server" Skin="Web20" |
| ToolsFile="ArtistToolsFile.xml" Width="550px"> |
| <content> |
| </content></telerik:RadEditor> |
| |
| |
| </telerik:RadPageView> |
| </telerik:RadMultiPage> |
