如何根据下拉选项制作一个按钮来过滤我的表格？ （。净） [英] How can I make a button filter my table based off of dropdown choice? (.Net)
本文介绍了如何根据下拉选项制作一个按钮来过滤我的表格？ （。净）的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！
问题描述
I'm trying to make a program in Visual Studio using asp.net that displays the results of a SQL Database in an HTML repeater table. I'm attempting to filter the data within the table so that you are able to display members who are "termed" or members who are "active".
Here is my code so far
<%@ Page Language="C#" AutoEventWireup="True" %>
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<link rel="stylesheet" href="http://maxcdn.bootstrapcdn.com/bootstrap/3.2.0/css/bootstrap.min.css">
<link rel="stylesheet" href="http://maxcdn.bootstrapcdn.com/bootstrap/3.2.0/css/bootstrap-theme.min.css">
<script src="http://maxcdn.bootstrapcdn.com/bootstrap/3.2.0/js/bootstrap.min.js"></script>
<script src="http://code.jquery.com/jquery.min.js"></script>
<script src="js/bootstrap.min.js"></script>
<link rel="stylesheet" type="text/css" href="//cdn.datatables.net/1.10.2/css/jquery.dataTables.css">
<script type="text/javascript" charset="utf8" src="//cdn.datatables.net/1.10.2/js/jquery.dataTables.js"></script>
</head>
<script runat="server">
void Search_Click(object sender, EventArgs e)
{
<!-- This is the part I was most confused about. I need help on what to put here -->
@Title = DropDownList1.SelectedValue;
}
</script>
<body>
<form id="Form1" action="demo_form_action.asp" runat="server" method="get">
<asp:Button ID="Submit1" OnClick="Search_Click"
Text="Log Out" runat="server" />
<asp:DropDownList ID="DropDownList1" runat="server">
<asp:ListItem Selected>Activated</asp:ListItem>
<asp:ListItem>Termed</asp:ListItem>
</asp:DropDownList>
</div>
<div>
<asp:Repeater ID="Repeater1" runat="server"
DataSourceID="SqlDataSource1">
<HeaderTemplate>
<table id="table_id" class="display">
<thead>
<tr>
<th>Subscriber ID</th>
<th>First Name</th>
<th>Last Name</th>
<th>Birthdate</th>
<th>Provider ID</th>
<th>Payer</th>
<th>HICN</th>
<th>Medicare No.</th>
<th>Medicaid No.</th>
<th>Status</th>
</tr>
</thead>
<tbody>
</HeaderTemplate>
<ItemTemplate>
<tr>
<td bgcolor="#CCFFCC">
<asp:Label runat="server" ID="Label1"
text='<%# Eval("CoverageID") %>' />
</td>
<td bgcolor="#CCFFCC">
<asp:Label runat="server" ID="Label2"
text='<%# Eval("FirstName") %>' />
</td>
<td bgcolor="#CCFFCC">
<asp:Label runat="server" ID="Label3"
text='<%# Eval("LastName") %>' />
<td bgcolor="#CCFFCC">
<asp:Label runat="server" ID="Label4"
text='<%# Eval("DOB") %>' />
</td>
<td bgcolor="#CCFFCC">
<asp:Label runat="server" ID="Label5"
text='<%# Eval("ProviderID") %>' />
</td>
<td bgcolor="#CCFFCC">
<asp:Label runat="server" ID="Label6"
text='<%# Eval("HPName") %>' />
</td>
<td bgcolor="#CCFFCC">
<asp:Label runat="server" ID="Label7"
text='<%# Eval("HPOtherID") %>' />
</td>
<td bgcolor="#CCFFCC">
<asp:Label runat="server" ID="Label8"
text='<%# Eval("MedicalID") %>' />
</td>
<td bgcolor="#CCFFCC">
<asp:Label runat="server" ID="Label9"
text='<%# Eval("MedicareID") %>' />
</td>
<td bgcolor="#CCFFCC">
<asp:Label runat="server" ID="Label10"
text='<%# Eval("StatusName") %>' />
</td>
</tr>
</ItemTemplate>
<FooterTemplate>
</tbody>
</table>
</FooterTemplate>
</asp:Repeater>
<asp:SqlDataSource
DataSourceMode = "Dataset"
Enablecaching = "true"
ConnectionString=
"<%$ ConnectionStrings:UACConnectionString %>"
ID="SqlDataSource1" runat="server"
SelectCommand="SELECT DISTINCT MemberCoverages.CoverageID, Members.FirstName, Members.LastName, Members.DOB, MemberCoverages.ProviderID, HealthPlans.HPName, MemberCoverages.HPOtherID, MemberCoverages.MedicalID, MemberCoverages.MedicareID, StatusCodes.StatusName
FROM MemberCoverages
Join Members
ON MemberCoverages.MemberID=Members.MemberID
Join HealthPlans
ON MemberCoverages.HPID=HealthPlans.HPID
Join StatusCodes
ON Membercoverages.StatusID=StatusCodes.StatusID
WHERE [TermDate] IS NULL AND StatusName = @Title;">
<SelectParameters>
<asp:ControlParameter Name ="Title" ControlID="DropDownList1" PropertyName="SelectedValue" />
</SelectParameters>
</asp:SqlDataSource>
</div>
</form>
</body>
</html>
So my app starts by displaying all members with a StatusName of "Active". And ideally, I want it to filter based off of the selected dropdown whenever the "Search_1" button is clicked. However, whenever I change the dropdown to "Termed" and click the button, I receive an error page that says "HTTP Error 414. The request URL is too long".
So how can I make the Search_Click function filter based off of my dropdown choice?
I'm new to programming so please explain in a clear and basic terminology if you can. I appreciate all help. :)
推荐答案
ConnectionStrings：UACConnectionString％>
ID =SqlDataSource1runat =server
SelectCommand =SELECT DISTINCT MemberCoverages.CoverageID，Members.FirstName，Members.LastName，Members.DOB，MemberCoverages.ProviderID，HealthPlans.HPName，MemberCoverages.HPOtherID，MemberCoverages.MedicalID，MemberCoverages.MedicareID，StatusCodes.StatusName
FROM MemberCoverages
加入会员
ON MemberCoverages.MemberID = Members.MemberID
加入HealthPlans
ON MemberCoverages.HPID = HealthPlans.HPID
加入StatusCodes
ON Membercoverages。 StatusID = StatusCodes.StatusID
WHERE [TermDate] IS NULL AND StatusName = @Title;>
< SelectParameters>
< asp：ControlParameter Name =TitleControlID =DropDownList1 PropertyName =SelectedValue/>
< / SelectP arameters>
< / asp：SqlDataSource>
< / div>
< / form>
< / body>
< / html>
所以我的应用程序首先显示StatusName为Active的所有成员。理想情况下，只要单击Search_1按钮，我希望它根据所选下拉列表进行过滤。但是，每当我将下拉列表更改为Termed并单击该按钮时，我会收到一个错误页面，上面写着HTTP错误414.请求URL太长。
那么如何根据我的下拉选项制作Search_Click函数过滤器？
我是编程新手所以如果可以，请用清晰的基本术语解释。我感谢所有的帮助。 :)
ConnectionStrings:UACConnectionString %>" ID="SqlDataSource1" runat="server" SelectCommand="SELECT DISTINCT MemberCoverages.CoverageID, Members.FirstName, Members.LastName, Members.DOB, MemberCoverages.ProviderID, HealthPlans.HPName, MemberCoverages.HPOtherID, MemberCoverages.MedicalID, MemberCoverages.MedicareID, StatusCodes.StatusName FROM MemberCoverages Join Members ON MemberCoverages.MemberID=Members.MemberID Join HealthPlans ON MemberCoverages.HPID=HealthPlans.HPID Join StatusCodes ON Membercoverages.StatusID=StatusCodes.StatusID WHERE [TermDate] IS NULL AND StatusName = @Title;"> <SelectParameters> <asp:ControlParameter Name ="Title" ControlID="DropDownList1" PropertyName="SelectedValue" /> </SelectParameters> </asp:SqlDataSource> </div> </form> </body> </html> So my app starts by displaying all members with a StatusName of "Active". And ideally, I want it to filter based off of the selected dropdown whenever the "Search_1" button is clicked. However, whenever I change the dropdown to "Termed" and click the button, I receive an error page that says "HTTP Error 414. The request URL is too long". So how can I make the Search_Click function filter based off of my dropdown choice? I'm new to programming so please explain in a clear and basic terminology if you can. I appreciate all help. :)
简单地说HTTP 414，你得到的错误信息是自我解释请求URL太长。你能在网页上查看超过限制的内容吗？
Simply put HTTP 414, the error message you are getting is self explanatory "The request URL is too long". Can you check whats so long in the url that the limit is crossed.
这篇关于如何根据下拉选项制作一个按钮来过滤我的表格？ （。净）的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
查看全文
