需要从ASP传递动态值.NET文本框到报表查看器中
本文关键字:报表 文本 NET ASP 动态 | 更新日期: 2023-09-27 18:15:50
我认为这是基本的,但我是新的报告工具。
我有一个web表单,我有几个输入控件,我需要从数据库获取值,让他们填充到一个报告。我必须能够在Excel或PDF中获得报告,因此,我选择了提供这些功能的报告查看器。请检查我下面的代码,并给我一个代码或想法,如何通过传递输入参数来开发报告,并得到生成的报告。我的ASPX代码是:
<section id="content" class="has-btn-bar-btm-fixed"><!-- content -->
<form runat="server" class="form-horizontal custom-form row">
<div class="cost-transfer-block"><!-- cost-transfer-block -->
<div class="container-fluid">
<div class="row">
<div class="col-md-8 col-lg-10">
<h2>Dump by item</h2>
<div class="col-md-6">
<div class="form-group">
<asp:label runat="server" Text="From Site" ID="lblFromSite" class="control-label col-sm-3 col-md-3 col-lg-3" ></asp:label>
<div class="col-sm-9">
<div class="input-group">
<select class="form-control">
<asp:DropDownList ID="DdlFromsite" runat="server" ></asp:DropDownList>
</select>
<span class="input-group-addon"><a href="javascript:;"> </a></span>
</div>
</div>
</div>
</div>
<div class="col-md-6 cst-brd-left">
<div class="form-group">
<asp:label runat="server" Text="From Date" ID="lblFromDate" class="control-label col-sm-3 col-md-3 col-lg-3" ></asp:label>
<div class="col-sm-9 transferdate">
<div class="input-group date">
<input type="date" class="form-control" id="" placeholder="Select Date" >
<span class="input-group-addon"><a href="javascript:;"><img src="images/icon-add-on-2-date.png" alt="" /></a></span>
</div>
</div>
</div>
<div class="form-group">
<asp:label runat="server" Text="To Date" ID="lblToDate" class="control-label col-sm-3 col-md-3 col-lg-3" >To Date</asp:label>
<div class="col-sm-9 transferdate">
<div class="input-group date">
<input type="date" class="form-control" id="" placeholder="Select Date" >
<span class="input-group-addon"><a href="javascript:;"><img src="images/icon-add-on-2-date.png" alt="" /></a></span>
</div>
</div>
</div>
</div>
</div>
<div class="col-md-4 col-lg-2">
</div>
</div>
</div>
</div>
<!-- /cost-transfer-block -->
<div class="gray-btn-row clearfix">
<div class="btns-group">
<asp:button runat="server" Text="Enter" ID="btnEnter" class="btn btn-dark-blue"></asp:button>
</div>
</div>
</form>
</section>
请给我一个代码或一个想法,使用它我可以通过点击回车键生成一个报告。
Thanks in Advance,
Deepak
在单击按钮时调用Ajax ExportFile方法。
public void ExportFile(Parameter1,parameter2)
{
var data ="Fire Query in database using Parameter and Get Data";
Response.ClearContent();
Response.AddHeader("content-disposition", "attachment;filename=Report.xlsx");
Response.AddHeader("Content-Type", "application/vnd.ms-excel");
ExcelPackage objExcel = new ExcelPackage();
ExcelWorksheet reportsheet = objExcel.Workbook.Worksheets.Add("Report");
reportsheet.Cells["A1"].LoadFromDataTable(AccessHelper.ToLocationDataTable(data), true);
objExcel.Save();
using (MemoryStream MyMemoryStream = new MemoryStream())
{
objExcel.SaveAs(MyMemoryStream);
MyMemoryStream.WriteTo(Response.OutputStream);
Response.Flush();
Response.End();
}
}