Gridview not showing up when a value in drop down column is selected

See more:

C#

ASP.NET

SQL

Hi,

I currently have a drop down list that has values from a column in a database bound to it. I have c# code that i need to change the displayed data in the gridview depending on the selected value from the drop down list.

At the moment, there is no errors at all when running, however the gridview is not appearing.

Any help will be appreciated!

Page Load C#

protected void Page_Load(object sender, EventArgs e)
        {
            if (!IsPostBack)
            {
                SqlConnection con = new SqlConnection(@"Data Source=(local)\;Initial Catalog=SmallBatch;Integrated Security=True;");

                con.Open();

                String getState = "Select Username From Site ";


                DataTable dt = new DataTable();
                SqlDataAdapter da = new SqlDataAdapter(getState, con);
                da.Fill(dt);


                DropDownList1.DataSource = dt;
                DropDownList1.DataTextField = "Username";
                DropDownList1.DataValueField = "Username";
                DropDownList1.DataBind();


                con.Close();
            }

Selected Index Changed C#

protected void DropDownList1_SelectedIndexChanged(object sender, EventArgs e)
       {
           SqlConnection con = new SqlConnection(@"Data Source=(local)\;Initial Catalog=SmallBatch;Integrated Security=True;");
           SqlDataAdapter DataAdapter = new SqlDataAdapter(string.Format("SELECT Stock_Take.Username, Item.ItemID, Item.ItemDesc, Stock_Take_Item.BarQuantity, Stock_Take_Item.StorageQuantity, Stock_Take.StockTakeIDNew 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 + "'"), con);

           DataTable table = new DataTable();
           DataAdapter.Fill(table);
           GridView1.DataSource = table;
           GridView1.DataBind();
       }

Gridview code

<asp:DropDownList ID="DropDownList1" runat="server" OnSelectedIndexChanged="DropDownList1_SelectedIndexChanged"></asp:DropDownList>
            
            <asp:GridView ID="GridView1" runat="server" BackColor="White" BorderColor="#CCCCCC" BorderStyle="None" BorderWidth="1px" CellPadding="4" ForeColor="Black" GridLines="Horizontal">
                <FooterStyle BackColor="#CCCC99" ForeColor="Black" />
                <HeaderStyle BackColor="#333333" Font-Bold="True" ForeColor="White" />
                <PagerStyle BackColor="White" ForeColor="Black" HorizontalAlign="Right" />
                <SelectedRowStyle BackColor="#CC3333" Font-Bold="True" ForeColor="White" />
                <SortedAscendingCellStyle BackColor="#F7F7F7" />
                <SortedAscendingHeaderStyle BackColor="#4B4B4B" />
                <SortedDescendingCellStyle BackColor="#E5E5E5" />
                <SortedDescendingHeaderStyle BackColor="#242121" />

                <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>

What I have tried:

I have tried populating the gridview in a seperate method, but still same result.