如何从下拉列表中获取所选值以填充gridview？ [英] How to get the selected value from drop down list to populate gridview?

问题描述

我目前有两个下拉列表和一个GridView。用户在第一个下拉列表中选择一个值，该值过滤第二个下拉列表中的值，然后用户选择第二个下拉列表中的值，该列表应根据下拉列表中的两个值填充GridView名单。



下拉列表正在运行，第二个下拉列表会根据第一个下拉列表的值而变化。然而gridview是1.没有出现在我的浏览器和2.我认为没有填充。



任何帮助非常感谢！



C＃DropDownList2上所选索引变化的代码

Hi, I've currently got two drop down lists and a GridView. The user selects a value in the first drop down list which filters the values in the second drop down list, then the user selects the value in the second drop down list which should in turn populate the GridView based off the two values in the drop down lists.

The drop down lists are working and the second drop down list changes depending on the value of the first. However the gridview is 1. Not showing up on my browser and 2. I presume not populating.

Any help is much appreciated!

C# Code of the selected index change on the DropDownList2

protected void DropDownList2_SelectedIndexChanged(object sener, EventArgs e)
       {
           DataTable table = new DataTable();
           using (SqlConnection con = new SqlConnection(@"Data Source=(local)\;Initial Catalog=SmallBatch;Integrated Security=True;"))
           {
               con.Open();
               SqlDataAdapter DataAdapter = new SqlDataAdapter(string.Format("SELECT Item.ItemID, Item.ItemDesc, Stock_Take_Item.BarQuantity, Stock_Take_Item.StorageQuantity FROM Item INNER JOIN Stock_Take_Item ON Item.ItemID = Stock_Take_Item.ItemID INNER JOIN Stock_Take ON Stock_Take_Item.StockTakeIDNew = Stock_Take.StockTakeIDNew where Stock_Take.Username = '" + DropDownList1.SelectedValue + "' AND Stock_Take.StockDate = '" + DropDownList1.SelectedValue + "'"), con);
               DataAdapter.Fill(table);
           }

           GridView1.DataSource = table;
           GridView1.DataBind();

       }

我的Gridview代码（样式取出） -

Code of my Gridview (Styling taken out) -

<asp:GridView ID="GridView1" runat="server" BackColor="White" BorderColor="#CCCCCC" BorderStyle="None" BorderWidth="1px" CellPadding="4" ForeColor="Black" GridLines="Horizontal" OnSelectedIndexChanged="GridView1_SelectedIndexChanged" AutoGenerateColumns="false" AutoPostBack="True">
                

                <Columns>
                    <asp:TemplateField HeaderText="Item ID" HeaderStyle-CssClass="gridview-header">
                        <ItemTemplate>
                            <asp:Label ID="itemIDAdmin" Text='<%# Eval("ItemID")%>' runat="server"></asp:Label>
                        </ItemTemplate>
                    </asp:TemplateField>
                    
                    <asp:TemplateField HeaderText="Item Description" HeaderStyle-CssClass="gridview-header">
                        <ItemTemplate>
                            <asp:Label ID="itemDescAdmin" Text='<%# Eval("ItemDesc")%>' runat="server"></asp:Label>
                        </ItemTemplate>
                    </asp:TemplateField>
                      
                    <asp:TemplateField HeaderText="Bar Quantity" HeaderStyle-CssClass="gridview-header">
                        <ItemTemplate>
                            <asp:Label ID="barQuantityAdmin" Text='<%# Eval("BarQuantity")%>' runat="server"></asp:Label>
                        </ItemTemplate>
                    </asp:TemplateField>
                    
                    <asp:TemplateField HeaderText="Storage Quantity" HeaderStyle-CssClass="gridview-header">
                        <ItemTemplate>
                            <asp:Label ID="storageQuantityAdmin" Text='<%# Eval("StorageQuantity")%>' runat="server"></asp:Label>
                        </ItemTemplate>
                    </asp:TemplateField>

                </Columns>




            </asp:GridView>

我的尝试：



我一直试图解决这个问题一段时间但无法得到任何答案。

What I have tried:

I have been trying to solve this problem for a while but cannot get any answers.

推荐答案

你可以重新检查你的代码

can you recheck your code

where Stock_Take.Username = '" + DropDownList1.SelectedValue + "' AND Stock_Take.StockDate = '" + DropDownList1.SelectedValue + "'"

我认为Stockdate和用户名的值不应该是相同。

I think the value of Stockdate and username should not be same.

尝试使用Update中的网格视图来更新基于其他控件的内容。

Try to use Grid View in Update to update content based on other controls.

这篇关于如何从下拉列表中获取所选值以填充gridview？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！