ASP.NET MVC C# - Pass dynamic parameter using URL ACTION

Question

How can I pass the value of my textbox "R_endDate" from my VIEW to my controller ExportToExcel function using Url.Action ?

On my View: Index.cshtml

I have this textbox with value of date.

<div class="uk-form-row">
    <label class="uk-form-label" for="R_endDate">Ending Date:</label>
    <div class="uk-form-controls">
        @Html.TextBoxFor(m => m.R_endDate, new { @class = "uk-form-small uk-text-left required", @maxlength = 12, @data_uk_datepicker = "{format: 'MM/DD/YYYY'}" })

    </div>
</div>

I have this anchor tag with url action.

<a href="@Url.Action("ExportToExcel")" class="uk-button uk-button-small uk-text-center uk-text-small ">Export</a>

On my Controller: MISReportController.cs

 public FileContentResult ExportToExcel()
    {
    byte[] filecontent = ExcelExportHelper.ExportExcel(list, "Technology", true, strAddtional);
    return File(filecontent, ExcelExportHelper.ExcelContentType, strTitle);

    }

my scripts

error1

You can better handle anchor click in JavaScript or modify anchor href in javscript code, for example stackoverflow.com/a/12250499/713789 — Anirudha Gupta
– Anirudha Gupta, Commented May 15, 2018 at 6:48
You cant - @Url.Action() is razor code. It is paersed on the server before the view is sent to the browser. Use a form (with FormMethod.Get and post the form to you method), or use javascript to build the url — user3559349
– user3559349, Commented May 15, 2018 at 6:50

jegtugado · Accepted Answer · 2018-05-15 07:43:39Z

3

You can easily handle this using javascript/jquery.

UI:

<a id="aExportToExcel" href="#" class="uk-button uk-button-small uk-text-center uk-text-small ">Export</a>

Script:

<script type="text/javascript">

$(document).ready(function () {
    $("#aExportToExcel").click(function () {
        var param = $("input[name='R_endDate']").val();
        var _url = '@Url.Action("ExportToExcel", "MISReportController", new { param = "XXX" })'; // Param is the example parameter name. Change as needed.
        _url = _url.replace("XXX", param); // _url will contain your url string so you can just play with it as needed for your requirement.

        window.open(_url, "_blank");
    });
});

</script>

edited May 15, 2018 at 7:43

answered May 15, 2018 at 6:53

jegtugado

5,1511 gold badge14 silver badges35 bronze badges

Sign up to request clarification or add additional context in comments.

15 Comments

Mohan Srinivas Over a year ago

ajax call is better than this one?

Jadina Over a year ago

public FileContentResult ExportToExcel(string param), when I check the param value it is null. Any idea sir?

jegtugado Over a year ago

@MohanSrinivas why is it better? @Jadina check the name of your textbox, I simply assumed it was R_endDate. Change if the razor-generated name is different.

Mohan Srinivas Over a year ago

Just pass the model value as a data while click the link and get the result right?

jegtugado Over a year ago

@MohanSrinivas based on my experience with file downloading using ajax, it will not be downloaded as is because your success callback will have to handle blob data. But if you prefer to persue that approach then you may. I am not qualified to decide which is better.

|

Bhinni · Accepted Answer · 2018-05-15 10:52:51Z

0

try using html helper beginform()

in index.cshtml

   @using (Html.BeginForm("ExportToExcel", "MISReport")) {<div class="uk-form-row">
<label class="uk-form-label" for="R_endDate">Ending Date:</label>
<div class="uk-form-controls">
    @Html.TextBoxFor(m => m.R_endDate, new { @class = "uk-form-small uk-text-left required", @maxlength = 12, @data_uk_datepicker = "{format: 'MM/DD/YYYY'},@name="date" })</div></div>}

in the controller

      [HttpPost]public FileContentResult ExportToExcel(Datetime date){ .......

}

answered May 15, 2018 at 10:52

Bhinni

315 bronze badges

Collectives™ on Stack Overflow

ASP.NET MVC C# - Pass dynamic parameter using URL ACTION

2 Answers 2

15 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

15 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related