or
Hi,
Please let me know how to passPROJECT_ID value to my btnAddNew. so when i click on my button, i will direct me to the new page with value of Project_ID.
Thanks so much in advance.
<
telerik:RadGrid
ID
=
"gvFSRMSearchResult"
runat
=
"server"
ShowStatusBar
=
"true"
AutoGenerateColumns
=
"False"
PageSize
=
"5"
OnSortCommand
=
"GVSortCommand"
OnPageIndexChanged
=
"GVProject1PageIndexChanged"
OnPageSizeChanged
=
"GVProjectPageSizeChanged"
AllowSorting
=
"True"
AllowMultiRowSelection
=
"False"
AllowPaging
=
"True"
GridLines
=
"Both"
AllowMultiRowEdit
=
"false"
Skin
=
"Sunset"
Width
=
"100%"
AllowAutomaticInserts
=
"True"
OnDetailTableDataBind
=
"gvFSRMSearchResult_DetailTableDataBind"
AllowAutomaticDeletes
=
"True"
AllowAutomaticUpdates
=
"True"
>
<
PagerStyle
Mode
=
"NumericPages"
></
PagerStyle
>
<%--project_id is querystring passing to the child table--%>
<
MasterTableView
DataKeyNames
=
"PROJECT_ID"
AutoGenerateColumns
=
"false"
>
<
DetailTables
>
<
telerik:GridTableView
DataKeyNames
=
"project_id"
Name
=
"PCRHistory"
Width
=
"100%"
CommandItemDisplay
=
"Bottom"
>
<
Columns
>
<
telerik:GridHyperLinkColumn
ItemStyle-ForeColor
=
"Blue"
HeaderText
=
"Request Status"
DataNavigateUrlFields
=
"project_id"
DataNavigateUrlFormatString
=
"ProjectCancel.aspx?ProjectNumber={0}"
DataTextField
=
"Status_Code"
>
</
telerik:GridHyperLinkColumn
>
<
telerik:GridBoundColumn
SortExpression
=
"Reason"
HeaderText
=
"Reason"
HeaderButtonType
=
"TextButton"
DataField
=
"Reason_Description"
>
</
telerik:GridBoundColumn
>
<
telerik:GridBoundColumn
SortExpression
=
"REASON_OTHER_EXPLAIN"
HeaderText
=
"Other Reason"
HeaderButtonType
=
"TextButton"
DataField
=
"REASON_OTHER_EXPLAIN"
>
</
telerik:GridBoundColumn
>
<
telerik:GridBoundColumn
SortExpression
=
"Project_id"
Visible
=
"true"
HeaderButtonType
=
"TextButton"
DataField
=
"Project_id"
>
</
telerik:GridBoundColumn
>
</
Columns
>
<
CommandItemTemplate
>
<
div
style
=
"padding: 5px 5px;"
>
<
asp:ImageButton
ID
=
"btnAddNew"
runat
=
"server"
OnClick
=
"btnAddNew_Click"
ImageUrl
=
"~/Images/buttons/newrecord_icon.png"
/>
</
div
>
</
CommandItemTemplate
>
</
telerik:GridTableView
>
</
DetailTables
>
<
Columns
>
<
telerik:GridBoundColumn
SortExpression
=
"PROJECT_ID"
HeaderText
=
"PROJECT ID"
HeaderButtonType
=
"TextButton"
DataField
=
"PROJECT_ID"
>
</
telerik:GridBoundColumn
>
<
telerik:GridBoundColumn
DataField
=
"PRJ_STATUS"
Display
=
"false"
HeaderText
=
"PRJ_STATUS"
>
</
telerik:GridBoundColumn
>
<
telerik:GridBoundColumn
DataField
=
"TITLE"
SortExpression
=
"title"
HeaderText
=
"TITLE"
>
</
telerik:GridBoundColumn
>
</
Columns
>
</
MasterTableView
>
</
telerik:RadGrid
>
protected
void
btnAddNew_Click(
object
sender, EventArgs e)
{
Response.Redirect(
"PCRNew.aspx?projectId=project_id"
;
}
<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="ManageOverrides.aspx.cs"
Inherits="AdminWebsite.ManageOverrides" MasterPageFile="~/Admin.Master" %>
<%@ Register Assembly="AjaxControlToolkit" Namespace="AjaxControlToolkit" TagPrefix="cc1" %>
<%@ Register Assembly="Telerik.Web.UI" Namespace="Telerik.Web.UI" TagPrefix="telerik" %>
<
asp:Content
ID
=
"Content1"
ContentPlaceHolderID
=
"ContentPlaceHolder1"
runat
=
"server"
>
<
telerik:RadCodeBlock
ID
=
"RadCodeBlock1"
runat
=
"server"
>
<
script
type
=
"text/javascript"
>
function ShowEditForm(EntityID, EntityType, MaintenanceLong, MaintenanceShort, InitialLong, InitialShort, DayTradeLong, DayTradeShort) {
window.radopen("ManageOverridesEdit.aspx?EntityID=" + EntityID + "&EntityType=" + EntityType + "&MaintenanceLong=" + MaintenanceLong + "&MaintenanceShort=" + MaintenanceShort + "&InitialLong=" + InitialLong + "&InitialShort=" + InitialShort + "&DayTradeLong=" + DayTradeLong + "&DayTradeShort=" + DayTradeShort, "ManageOverridesEdit");
}
</
script
>
</
telerik:RadCodeBlock
>
<
telerik:radwindowmanager
id
=
"RadWindowManager2"
runat
=
"server"
enableshadow
=
"true"
skin
=
"Office2007"
initialbehavior
=
"Close"
behavior
=
"Close,Move"
>
<
Windows
>
<
telerik:RadWindow
ID
=
"ManageOverridesEdit1"
runat
=
"server"
Title
=
"Manage Overrides Edit"
Skin
=
"Office2007"
Height
=
"500px"
Width
=
"800px"
Left
=
"100px"
ReloadOnShow
=
"false"
VisibleStatusbar
=
"true"
ShowContentDuringLoad
=
"true"
Modal
=
"true"
Behavior
=
"Minimize,Maximize,Close,Move"
/>
</
Windows
>
</
telerik:radwindowmanager
>
<
asp:Panel
ID
=
"pnlSecuritySearchResults"
runat
=
"server"
Width
=
"60%"
Visible
=
"false"
>
<
telerik:RadGrid
ID
=
"rgSecuritySearchResults"
runat
=
"server"
AutoGenerateColumns
=
"False"
GridLines
=
"None"
Skin
=
"Office2007"
AllowPaging
=
"True"
OnItemDataBound
=
"rgSecuritySearchResults_ItemDataBound"
DataSourceID
=
"SecurityOverridesDS"
OnDeleteCommand
=
"rgSecuritySearchResults_ItemCommand"
>
<
MasterTableView
DataSourceID
=
"SecurityOverridesDS"
DataKeyNames
=
"EntityID,EntityType,CUSIP"
>
<
RowIndicatorColumn
>
<
HeaderStyle
Width
=
"20px"
></
HeaderStyle
>
</
RowIndicatorColumn
>
<
ExpandCollapseColumn
>
<
HeaderStyle
Width
=
"20px"
></
HeaderStyle
>
</
ExpandCollapseColumn
>
<
Columns
>
<
telerik:GridTemplateColumn
DataField
=
"Action"
HeaderButtonType
=
"TextButton"
HeaderText
=
"Action"
UniqueName
=
"Action"
>
<
HeaderStyle
HorizontalAlign
=
"Center"
/>
<
ItemStyle
HorizontalAlign
=
"Center"
/>
<
ItemTemplate
>
<
asp:ImageButton
ID
=
"ImgDelete"
ToolTip
=
"Click here to Delete"
CommandName
=
"Delete"
runat
=
"server"
Text
=
"Delete"
ImageUrl
=
"images/Delete.gif"
OnClientClick
=
"if (!confirm('Are You sure you want to delete the selected security override ?')) return false;"
/>
<
asp:ImageButton
ID
=
"imgBtnEdit"
ImageUrl
=
"images/radgrid/Edit.gif"
ToolTip
=
"Click here to Edit"
Text
=
"Edit"
runat
=
"server"
CommandName
=
"Edit"
/>
</
ItemTemplate
>
</
telerik:GridTemplateColumn
>
<
telerik:GridTemplateColumn
HeaderText
=
"Entity ID"
UniqueName
=
"EntityID"
DataField
=
"EntityID"
SortExpression
=
"EntityID"
>
<
ItemTemplate
>
<
asp:Label
runat
=
"server"
ID
=
"lblEntityID"
Text='<%# DataBinder.Eval(Container.DataItem, "EntityID")%>'></
asp:Label
>
</
ItemTemplate
>
</
telerik:GridTemplateColumn
>
<
telerik:GridTemplateColumn
HeaderText
=
"Entity Type"
UniqueName
=
"EntityType"
DataField
=
"EntityType"
SortExpression
=
"Symbol"
>
<
ItemTemplate
>
<
asp:Label
runat
=
"server"
ID
=
"lblEntityType"
Text='<%# DataBinder.Eval(Container.DataItem, "EntityType")%>'></
asp:Label
>
</
ItemTemplate
>
</
telerik:GridTemplateColumn
>
<
telerik:GridBoundColumn
HeaderText
=
"Symbol"
UniqueName
=
"Symbol"
DataField
=
"Symbol"
SortExpression
=
"Symbol"
>
</
telerik:GridBoundColumn
>
<
telerik:GridBoundColumn
HeaderText
=
"Correspondent Code"
UniqueName
=
"CorrespondentCode"
DataField
=
"CorrespondentID"
SortExpression
=
"CorrespondentCode"
>
</
telerik:GridBoundColumn
>
<
telerik:GridBoundColumn
HeaderText
=
"Office Code"
UniqueName
=
"OfficeCode"
DataField
=
"OfficeID"
SortExpression
=
"OfficeCode"
>
</
telerik:GridBoundColumn
>
<
telerik:GridBoundColumn
HeaderText
=
"Rep ID"
UniqueName
=
"RepID"
DataField
=
"RepID"
SortExpression
=
"RepID"
>
</
telerik:GridBoundColumn
>
<
telerik:GridBoundColumn
HeaderText
=
"Account Number"
UniqueName
=
"AccountNumber"
DataField
=
"AccountNumber"
SortExpression
=
"AccountNumber"
>
</
telerik:GridBoundColumn
>
<
telerik:GridTemplateColumn
HeaderText
=
"Maintenance Long"
UniqueName
=
"MaintenanceLong"
DataField
=
"MaintenanceLong"
SortExpression
=
"MaintenanceLong"
>
<
ItemTemplate
>
<
asp:Label
runat
=
"server"
ID
=
"lblMaintenanceLong"
Text='<%# DataBinder.Eval(Container.DataItem, "MaintenanceLong")%>'></
asp:Label
>
</
ItemTemplate
>
</
telerik:GridTemplateColumn
>
<
telerik:GridTemplateColumn
HeaderText
=
"Maintenance Short"
UniqueName
=
"MaintenanceShort"
DataField
=
"MaintenanceShort"
SortExpression
=
"MaintenanceShort"
>
<
ItemTemplate
>
<
asp:Label
runat
=
"server"
ID
=
"lblMaintenanceShort"
Text='<%# DataBinder.Eval(Container.DataItem, "MaintenanceShort")%>'></
asp:Label
>
</
ItemTemplate
>
</
telerik:GridTemplateColumn
>
<
telerik:GridTemplateColumn
HeaderText
=
"Initial Long"
UniqueName
=
"InitialLong"
DataField
=
"InitialLong"
SortExpression
=
"InitialLong"
>
<
ItemTemplate
>
<
asp:Label
runat
=
"server"
ID
=
"lblInitialLong"
Text='<%# DataBinder.Eval(Container.DataItem, "InitialLong")%>'></
asp:Label
>
</
ItemTemplate
>
</
telerik:GridTemplateColumn
>
<
telerik:GridTemplateColumn
HeaderText
=
"Initial Short"
UniqueName
=
"InitialShort"
DataField
=
"InitialShort"
SortExpression
=
"InitialShort"
>
<
ItemTemplate
>
<
asp:Label
runat
=
"server"
ID
=
"lblInitialShort"
Text='<%# DataBinder.Eval(Container.DataItem, "InitialShort")%>'></
asp:Label
>
</
ItemTemplate
>
</
telerik:GridTemplateColumn
>
<
telerik:GridTemplateColumn
HeaderText
=
"Day Trade Long"
UniqueName
=
"OldMaintenanceLong"
DataField
=
"OldMaintenanceLong"
SortExpression
=
"OldMaintenanceLong"
>
<
ItemTemplate
>
<
asp:Label
runat
=
"server"
ID
=
"lblDayTradeLong"
Text='<%# DataBinder.Eval(Container.DataItem, "OldMaintenanceLong")%>'></
asp:Label
>
</
ItemTemplate
>
</
telerik:GridTemplateColumn
>
<
telerik:GridTemplateColumn
HeaderText
=
"Day Trade Short"
UniqueName
=
"OldMaintenanceShort"
DataField
=
"OldMaintenanceShort"
SortExpression
=
"OldMaintenanceShort"
>
<
ItemTemplate
>
<
asp:Label
runat
=
"server"
ID
=
"lblDayTradeShort"
Text='<%# DataBinder.Eval(Container.DataItem, "OldMaintenanceShort")%>'></
asp:Label
>
</
ItemTemplate
>
</
telerik:GridTemplateColumn
>
<
telerik:GridBoundColumn
HeaderText
=
"Modified By"
UniqueName
=
"ModifiedBy"
DataField
=
"ModifiedBy"
SortExpression
=
"ModifiedBy"
>
</
telerik:GridBoundColumn
>
<
telerik:GridBoundColumn
HeaderText
=
"Modified Date"
UniqueName
=
"ModifiedDate"
DataField
=
"ModifiedDate"
SortExpression
=
"ModifiedDate"
>
</
telerik:GridBoundColumn
>
</
Columns
>
</
MasterTableView
>
<
ClientSettings
EnableRowHoverStyle
=
"true"
>
<
Selecting
AllowRowSelect
=
"True"
/>
</
ClientSettings
>
<
FilterMenu
EnableTheming
=
"True"
>
<
CollapseAnimation
Duration
=
"200"
Type
=
"OutQuint"
/>
</
FilterMenu
>
</
telerik:RadGrid
>
</
asp:Panel
>
<
asp:ObjectDataSource
ID
=
"odsCorrespondentFirm"
runat
=
"server"
OldValuesParameterFormatString
=
"original_{0}"
SelectMethod
=
"RetrieveAllFirmsFromCorrespondents"
TypeName
=
"AdminWebsite.CorrespondentDataSource"
onselecting
=
"odsCorrespondentFirm_Selecting"
>
</
asp:ObjectDataSource
>
<
asp:ObjectDataSource
ID
=
"SecurityOverridesDS"
runat
=
"server"
OldValuesParameterFormatString
=
"original_{0}"
onselecting
=
"SecurityOverridesDS_Selecting"
SelectMethod
=
"RetrieveAllSecurityOverridessWithEqualFilter"
TypeName
=
"AdminWebsite.SecurityRequirementOverridesDataSource"
DeleteMethod
=
"DeleteSecurityRequirementOverridesByID"
InsertMethod
=
"CreateSecurityRequirementOverrides"
UpdateMethod
=
"UpdateSecurityRequirementOverridesByID"
>
<
DeleteParameters
>
<
asp:Parameter
Name
=
"tokenId"
Type
=
"Object"
/>
<
asp:Parameter
DbType
=
"Guid"
Name
=
"callerId"
/>
<
asp:Parameter
Name
=
"entityID"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"entityType"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"cusip"
Type
=
"String"
/>
</
DeleteParameters
>
<
UpdateParameters
>
<
asp:Parameter
Name
=
"tokenId"
Type
=
"Object"
/>
<
asp:Parameter
DbType
=
"Guid"
Name
=
"callerId"
/>
<
asp:Parameter
Name
=
"entityID"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"entityType"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"cusip"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"maintenanceLong"
Type
=
"Decimal"
/>
<
asp:Parameter
Name
=
"maintenanceShort"
Type
=
"Decimal"
/>
<
asp:Parameter
Name
=
"initialLong"
Type
=
"Decimal"
/>
<
asp:Parameter
Name
=
"initialShort"
Type
=
"Decimal"
/>
<
asp:Parameter
Name
=
"description"
Type
=
"String"
/>
</
UpdateParameters
>
<
SelectParameters
>
<
asp:Parameter
Name
=
"tokenId"
Type
=
"Object"
/>
<
asp:Parameter
DbType
=
"Guid"
Name
=
"callerId"
/>
<
asp:ControlParameter
ControlID
=
"txtSymbol"
Name
=
"Symbol"
PropertyName
=
"Text"
Type
=
"String"
/>
<
asp:ControlParameter
Name
=
"firm"
Type
=
"String"
ControlID
=
"rcbFirm"
PropertyName
=
"SelectedValue"
/>
<
asp:ControlParameter
ControlID
=
"rcbOverrideLevel"
Name
=
"overrideLevel"
PropertyName
=
"SelectedValue"
Type
=
"String"
DefaultValue
=
"-1"
/>
</
SelectParameters
>
</
asp:ObjectDataSource
>
</
asp:Content
>
aspx.cs code
------------------
protected
void
rgSecuritySearchResults_ItemDataBound(
object
sender, GridItemEventArgs e)
{
if
(e.Item
is
GridDataItem)
{
GridDataItem dataItem = (GridDataItem)e.Item;
ImageButton imgBtnEdit = dataItem.FindControl(
"imgBtnEdit"
)
as
ImageButton;
Label lblEntityID = dataItem.FindControl(
"lblEntityID"
)
as
Label;
Label lblEntityType = dataItem.FindControl(
"lblEntityType"
)
as
Label;
Label lblMaintenanceLong = dataItem.FindControl(
"lblMaintenanceLong"
)
as
Label;
Label lblMaintenanceShort = dataItem.FindControl(
"lblMaintenanceShort"
)
as
Label;
Label lblInitialLong = dataItem.FindControl(
"lblInitialLong"
)
as
Label;
Label lblInitialShort = dataItem.FindControl(
"lblInitialShort"
)
as
Label;
Label lblDayTradeLong = dataItem.FindControl(
"lblDayTradeLong"
)
as
Label;
Label lblDayTradeShort = dataItem.FindControl(
"lblDayTradeShort"
)
as
Label;
string
strEntityID = lblEntityID.Text;
string
strEntityType = lblEntityType.Text;
string
strMaintenanceLong = lblMaintenanceLong.Text;
string
strMaintenanceShort = lblMaintenanceShort.Text;
string
strInitialLong = lblInitialLong.Text;
string
strInitialShort = lblInitialShort.Text;
string
strDayTradeLong = lblDayTradeLong.Text;
string
strDayTradeShort = lblDayTradeShort.Text;
imgBtnEdit.Attributes.Add(
"onclick"
,
"javascript:ShowEditForm('"
+ strEntityID +
"' ,'"
+ strEntityType +
"','"
+ strMaintenanceLong +
"','"
+ strMaintenanceShort +
"','"
+ strDayTradeLong +
"','"
+ strDayTradeShort +
"'); return false;"
);
}
Page load event in popup window is not fired when window opens and hence am not able to capture query strings passed
through window.radopen()to new popup window. I can see the query strings values in the status bar of pop up window.
But i cant capture the query string and hence cant edit grid row
If i can fire the page load event in pop up, then problem is solved.
Please advise on this or any alternate approaches.
Is it possible to create group column totals for every column without having to specify individual columns? My grid is actually a pivot table and my columns are generated dynamically by a sql statement that is created by drop down menus. There are 55 different combinations so I don’t want to have to program each individual column. My thought was to specify the group by’s and auto total the rest of the columns. For instance in this example, http://img843.imageshack.us/img843/3719/groupsql.jpg I would specify group by city and sex and the rest of the columns will total automatically. Any ideas will help. Thanks in advance.