How to pass RadMonthYearPicker value to DataNavigateUrlFormatStringn's DAtaNaigationURL

[Neetha]

I have a Radgrid and RadMonthYearPicker on the page. Radgrid contains hyperlink column, when click on the link along with DataNavigateUrlFields i have to pass value of the RadMonthYearPicker to the next page.

<telerik:RadMonthYearPicker ID="RadMonthYearPicker" runat="server" />
 <telerik:RadGrid .....................

<telerik:GridHyperLinkColumn DataTextField="Salesperson" UniqueName="Salesperson" HeaderStyle-Font-Bold="true" DataNavigateUrlFields="Salesperson,LoginName,MetricYear" HeaderStyle-HorizontalAlign="Center" ItemStyle-HorizontalAlign="Center" HeaderText="Salesperson" HeaderStyle-Width="20%"  DataNavigateUrlFormatString="DetailActivity.aspx?UserType=VP&amp;Salesperson={1}&amp;MetricYear={2}&amp;Picker=???"  /> 

</telerik: RadGrid>

Please let me know.


                 

                 

[Neetha]

Any idea how to do this?

[Shinu]

Hi Neetha,

You can add the RadMonthYearPicker from code behind as below:

ASPX:

<telerik:RadMonthYearPicker ID="RadMonthYearPicker" runat="server" AutoPostBack="true" OnSelectedDateChanged="RadMonthYearPicker_SelectedDateChanged">
</telerik:RadMonthYearPicker>

C#:

protected void RadGrid1_ItemDataBound(object sender, GridItemEventArgs e)
{
  if (e.Item is GridDataItem)
   {
     GridDataItem dataItem = (GridDataItem)e.Item;
     string loginName= dataItem["LoginName"].Text;
     string radMonthYearPickerValue = RadMonthYearPicker.SelectedDate.ToString();
     HyperLink hlinkSalesperson = (HyperLink)dataItem["Salesperson"].Controls[0];
     string salesPersonText= hlinkSalesperson .Text;
     link.NavigateUrl = "Default.aspx?Salesperson="+salesPersonText+"&Date="+radMonthYearPickerValue+"";
     //Similarly you can access other columns and set it to the Url
   }
}
protected void RadMonthYearPicker_SelectedDateChanged(object sender, Telerik.Web.UI.Calendar.SelectedDateChangedEventArgs e)
{
  RadGrid1.Rebind();
}

Thanks,
Shinu