private
DataTable GetProductCategories1(object categoryId)
{
SqlConnection connection = new SqlConnection(ConfigurationManager.ConnectionStrings["hakConnectionString"].ConnectionString);
SqlCommand selectCommand = new SqlCommand(@"Select * From Table911 where Left(Fld121,1) like '" + categoryId + "'" ,connection);
//selectCommand.Parameters.AddWithValue("parentId", categoryId);
SqlDataAdapter adapter = new SqlDataAdapter(selectCommand);
DataTable productCategories = new DataTable();
adapter.Fill(productCategories);
return productCategories;
}
<
body topmargin=0 leftmargin=0 >
<form id="form1" runat="server" >
<script language="javascript" type="text/javascript">
function openUnallocatedContacts()
{
//Use urlExtn to add a unique instance to the called page, to overcome IE7 Browser caching
var urlExtn = "ms=" + new Date().getTime();
var oWnd = radopen("ContactsUnallocated.aspx?" + urlExtn + "&OwnerId=" + <%= OwnerId %>
+
"&PlanId=" + <%= PlanId %>
+
"&SubPlanId=" + <%= SPlanId %> ,
"ContactsUnallocated" );
}
function openTabbedContacts(Id)
{
var urlExtn = "ms=" + new Date().getTime();
var oWnd = radopen("ContactTabbedDetails.aspx?" + urlExtn + "&ContactsID="
+ Id +
"&OwnerId=" + <%= OwnerId %> , "ContactTabbedDetails" );
}
</script>
<radW:RadWindowManager
ID="RadWindowManager1"
runat="server"
Overlay="true">
<Windows>
<radw:RadWindow
ID="ContactsUnallocated"
runat="server"
Skin = "Inox"
Width="900px"
Height="650px"
Top="60"
Left="50"
Modal="true"
>
</radw:RadWindow>
<radw:RadWindow
ID="ContactTabbedDetails"
runat="server"
Width="600px"
Height="500px"
Skin = "Inox"
Top="50"
Left="70"
Modal="true"
>
</radw:RadWindow>
</Windows>
</radW:RadWindowManager>
<div>
<table class="tblGradnt800" width="100%">
<tr>
<td class ="FrmHdrRow_GrdntCenter">
<asp:Label ID="lblbreadcrumb" runat="server"
Width="100%" BackColor="Transparent" ForeColor="WhiteSmoke" Font-Size="XX-Small"
>Allocated Contacts: </asp:Label>
</td>
</tr>
<tr>
<td
class ="TDInnerRowStyle_left">
<radG:RadGrid ID="GrvContacts"
runat="server"
EnableAJAX="true"
AutoGenerateColumns = "False"
AllowAutomaticDeletes="True"
AllowAutomaticInserts="True"
AllowAutomaticUpdates="false"
AllowSorting="True"
ShowStatusBar="True"
LoadingTemplateTransparency="50"
CssClass="GridVClass"
Width ="100%"
Height="100%"
CellPadding="4"
GridLines="None" AllowPaging="True"
EnableOutsideScripts="True"
EnableAJAXLoadingTemplate="True"
Visible="True"
HorizontalAlign="Left"
OnDeleteCommand="grvContDetails_DeleteCommand"
OnNeedDataSource="grvContDetails_NeedDataSource"
OnItemCommand="grvContDetails_ItemCommand"
SelectedItemStyle-BackColor="Gold"
EditItemStyle-BackColor="Gold" PageSize="15"
>
<
MasterTableView DataKeyNames="PersonId"
CommandItemDisplay="Top" >
<Columns>
<radG:GridTemplateColumn
HeaderText="Details"
UniqueName ="Edit"
DataField="Select" AutoPostBackOnFilter ="True">
<ItemTemplate >
<img src="../../RadControls/Grid/Skins/Default/Edit.gif"
onclick="openTabbedContacts('<%# DataBinder.Eval(Container.DataItem, "PersonId") %>');
return false;"
/>
</ItemTemplate>
<ItemStyle Width ="50px" HorizontalAlign="Left" />
<HeaderStyle Width ="50px" HorizontalAlign="Left" />
</radG:GridTemplateColumn>
<
radG:GridBoundColumn
.......
</
radG:GridButtonColumn>
</Columns>
<CommandItemTemplate>
<table width="100%" style="border-right: #003333 thin solid; border-top: #003333 thin solid; padding-bottom: 2px; margin: 1px; border-left: #003333 thin solid; padding-top: 2px; border-bottom: #003333 thin solid" >
<tr>
<td align="left" style="width: 50%">
<asp:LinkButton ID="LinkButton2"
runat="server"
OnClientClick="openUnallocatedContacts('<%= OwnerId %>');return false;">
<img style="border:0px"
alt=""
src="../../RadControls/Grid/Skins/AddRecord.gif"
/>Allocate Contacts to Plan
</asp:LinkButton>
</td>
<td align="right" style="width: 50%">
<asp:LinkButton ID="LinkButton4"
runat="server"
CommandName="Re bindGrid"
>
<img style="border:0px"
alt=""
src="../../RadControls/Grid/Skins/Refresh.gif" />
Refresh
</asp:LinkButton>
</td>
</tr>
</table>
</CommandItemTemplate>
<
body topmargin=0 leftmargin=0 >
<form id="form1" runat="server" >
<asp:scriptmanager ID="Scriptmanager1" runat="server"></asp:scriptmanager>
<script language="javascript" 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 CloseOnReload()
{
RefreshParentPage();
//Use this to get around the IE7 "Close, are you sure" dialog
window.opener = self;
window.open(
'~/CloseDummyIE7.htm', '_self');
window.close();
}
function RefreshParentPage()
{
GetRadWindow().BrowserWindow.location.reload();
}
function openTabbedContacts(Id)
{
var urlExtn = "ms=" + new Date().getTime();
var oWnd = radopen("ContactTabbedDetails.aspx?" + urlExtn + "&ContactsID="
+ Id +
"&OwnerId=" + <%= OwnerId %> , "TabCRM" );
}
</script>
<table class="tblGradnt800" width="100%" height="500px">
<tr>
<td
class ="TDInnerRowStyle_left">
<radG:RadGrid ID="GrvContacts"
runat
="server"
EnableAJAX ="true"
EnableOutsideScripts="True"
.........................etc
</radgrid><%
--
The button event responsible for calling the JavaScript function to close and reload the parent page
--
%>
<
tr>
<td align="right" height="20">
<asp:Button ID="Button1"
runat="server"
OnClick="btnSavePDetl_Click"
OnClientClick="CloseOnReload()"
Style="position: relative"
CssClass="GradntButton"
Text="Save&Close" />
</td>
</tr>
</table>
</div>
</form>
</
body>
</
html>
| <asp:ScriptManager ID="ScriptManager1" runat="server" EnablePartialRendering="true"></asp:ScriptManager> |
| <asp:UpdatePanel ID="UpdatePanel1" runat="server" UpdateMode="Always"> |
| <Triggers> |
| <asp:AsyncPostBackTrigger ControlID="btnSubmit" EventName="Click" /> |
| </Triggers> |
| <ContentTemplate> |
| <telerik:RadEditor |
| runat="server" |
| ID="RadEditor1" |
| Visible="true" |
| Skin="Default" |
| ToolbarMode="Default"> |
| <Tools> |
| <telerik:EditorToolGroup Tag="FirstBar"> |
| <telerik:EditorTool Name="Cut" /> |
| <telerik:EditorTool Name="Copy" /> |
| <telerik:EditorTool Name="Paste" /> |
| <telerik:EditorSeparator /> |
| <telerik:EditorTool Name="Undo" /> |
| <telerik:EditorTool Name="Redo" /> |
| <telerik:EditorSeparator /> |
| <telerik:EditorTool Name="FindAndReplace" /> |
| <telerik:EditorTool Name="AjaxSpellCheck" /> |
| <telerik:EditorSeparator /> |
| <telerik:EditorTool Name="Bold" /> |
| <telerik:EditorTool Name="Italic" /> |
| <telerik:EditorTool Name="Underline" /> |
| </telerik:EditorToolGroup> |
| </Tools> |
| </telerik:RadEditor> |
| </ContentTemplate> |
| </asp:UpdatePanel> |
| <br /> |
| <asp:Button ID="btnSubmit" runat="server" Text="Submit" CausesValidation="true" /> |

rotator1.TransitionType
rotator1.TransitionEffect
rotator1.SmoothScrollDelay
rotator1.UseSmoothScroll
rotator1.AutoPostBack
Kyle