Jquery数据表显示错误的行条目数 [英] Jquery datatable showing wrong number of row entries
本文介绍了Jquery数据表显示错误的行条目数的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！
问题描述
尝试为我的应用程序使用jquery dataTable插件，但我遇到了问题。如果表有两条记录，它会在表格中显示两条记录，然后显示显示1条记录中的1到1条。此外，我想将内容导出到Excel或复制到剪贴板。它只复制或导出一行。例如，如果我的dataTable有四行，它只复制一行，我会在页脚看到显示1到1个条目
< b>我尝试了什么：
Trying to make use of jquery dataTable plugin for my application but i have an issue with it. If the table has two records, it shows the two records on the table and then shows "Showing 1 to 1 of 1 entries" . Also, i want to export the content to excel or copy to clipboard. It only copies or export just one row. For example , if my dataTable has four rows, it only copy just one row and i get to see "Showing 1 to 1 of 1 entries" at the footer
What I have tried:
$(document).ready(function () {
$('#ex').dataTable({
destroy: true,
ordering: true,
responsive: true,
"paging": true,
"bAutoWidth": false,
"searching": true,
dom: 'Bfrtip',
buttons: [
'copyHtml5',
'excelHtml5',
'csvHtml5',
'pdfHtml5'
]
});
;
});
</script>
i也添加了以下苍蝇。注意：我在我的asp.net应用程序中使用它。
i have also added the following flies to it. Note: i'm using it in my asp.net application.
<script src="<%: ResolveUrl("plugins/datatables/jquery-3.2.1.js")%>"></script>
<script src="<%: ResolveUrl("plugins/jQueryUI/jquery-ui.js")%>"></script>
<script src="<%: ResolveUrl("plugins/datatables/jquery.dataTables.min.js")%>"></script>
<link href="<%: ResolveUrl("plugins/datatables/jquery.dataTables.min.css")%>" rel="stylesheet" />
<link href="<%: ResolveUrl("plugins/datatables/button.dataTables.min.css")%>" rel="stylesheet" />
<link href="<%: ResolveUrl("plugins/datatables/responsive.dataTables.min.css")%>" rel="stylesheet" />
<script src="<%: ResolveUrl("plugins/datatables/dataTables.responsive.min.js")%>"></script>
<script src="<%: ResolveUrl("plugins/datatables/dataTables.bootstrap.js")%>"></script>
<script src="<%: ResolveUrl("plugins/datatables/dataTables.buttons.min.js")%>"></script>
<script src= "<%: ResolveUrl("plugins/datatables/buttons.flash.min.js")%>"></script>
<script src="<%: ResolveUrl("plugins/datatables/jszip.min.js")%>"></script>
<script src="<%: ResolveUrl("plugins/datatables/pdfmake.min.js")%>"></script>
<script src="<%: ResolveUrl("plugins/datatables/vfs_fonts.js")%>"></script>
<script src= "<%: ResolveUrl("plugins/datatables/buttons.html5.min.js")%>"></script>
<script src="<%: ResolveUrl("plugins/datatables/buttons.print.min.js")%>"></script>
private void GenerateExcel(int coopId)
{
var coopmembers = coop.CoopMembers.Where(m => m.CoopId == coopId).ToList();
var loanApplication = coop.LoanApplications.Where(m => m.LoanStatus == "Running").ToList();
var query = (from c in coopmembers
join l in loanApplication on c.Member_Id equals l.MemeberId
select new
{
c.SubscriberCode,
c.FirstName,
c.LastName,
c.MiddleName,
l.ApplicationId,
l.MonthDeduction,
}).ToList();
Repeater.DataSource = query;
Repeater.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
int coopid = Convert.ToInt32(Session["CoopId"]);
GenerateExcel(coopid);
}
推荐答案
（ document ）。ready（< span class =code-keyword> function （）{
(document).ready(function () {
（' #ex'）。dataTable（{
destroy： true ，
订购： true ，
response： true ，
paging： true ，
bAutoWidth： false ，
搜索： true ，
dom：' Bfrtip'，
按钮：[
' copyHtml5'，
' excelHtml5'，
' csvHtml5'，
' pdfHtml5'
]
}）;
;
}）;
< / script>
('#ex').dataTable({ destroy: true, ordering: true, responsive: true, "paging": true, "bAutoWidth": false, "searching": true, dom: 'Bfrtip', buttons: [ 'copyHtml5', 'excelHtml5', 'csvHtml5', 'pdfHtml5' ] }); ; }); </script>
i也添加了以下苍蝇。注意：我在我的asp.net应用程序中使用它。
i have also added the following flies to it. Note: i'm using it in my asp.net application.
<script src="<%: ResolveUrl("plugins/datatables/jquery-3.2.1.js")%>"></script>
<script src="<%: ResolveUrl("plugins/jQueryUI/jquery-ui.js")%>"></script>
<script src="<%: ResolveUrl("plugins/datatables/jquery.dataTables.min.js")%>"></script>
<link href="<%: ResolveUrl("plugins/datatables/jquery.dataTables.min.css")%>" rel="stylesheet" />
<link href="<%: ResolveUrl("plugins/datatables/button.dataTables.min.css")%>" rel="stylesheet" />
<link href="<%: ResolveUrl("plugins/datatables/responsive.dataTables.min.css")%>" rel="stylesheet" />
<script src="<%: ResolveUrl("plugins/datatables/dataTables.responsive.min.js")%>"></script>
<script src="<%: ResolveUrl("plugins/datatables/dataTables.bootstrap.js")%>"></script>
<script src="<%: ResolveUrl("plugins/datatables/dataTables.buttons.min.js")%>"></script>
<script src= "<%: ResolveUrl("plugins/datatables/buttons.flash.min.js")%>"></script>
<script src="<%: ResolveUrl("plugins/datatables/jszip.min.js")%>"></script>
<script src="<%: ResolveUrl("plugins/datatables/pdfmake.min.js")%>"></script>
<script src="<%: ResolveUrl("plugins/datatables/vfs_fonts.js")%>"></script>
<script src= "<%: ResolveUrl("plugins/datatables/buttons.html5.min.js")%>"></script>
<script src="<%: ResolveUrl("plugins/datatables/buttons.print.min.js")%>"></script>
private void GenerateExcel(int coopId)
{
var coopmembers = coop.CoopMembers.Where(m => m.CoopId == coopId).ToList();
var loanApplication = coop.LoanApplications.Where(m => m.LoanStatus == "Running").ToList();
var query = (from c in coopmembers
join l in loanApplication on c.Member_Id equals l.MemeberId
select new
{
c.SubscriberCode,
c.FirstName,
c.LastName,
c.MiddleName,
l.ApplicationId,
l.MonthDeduction,
}).ToList();
Repeater.DataSource = query;
Repeater.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
int coopid = Convert.ToInt32(Session["CoopId"]);
GenerateExcel(coopid);
}
这篇关于Jquery数据表显示错误的行条目数的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
查看全文
