I'm trying to change the data of my gridlist on my homepage when you click on a button.. Tried many things nothing works. When I press the button to change gridview data nothing happpens and few secons later I get a error
How it looks: http://prntscr.com/7fa9qh The Error : http://prntscr.com/7faam0
I have left some code out to make it not all to big, like I only have 2 buttons in code but there are more
list.aspx.cs :
protected void Page_Load(object sender, EventArgs e) {
GvTop2000 usercontrol = (GvTop2000)Page.LoadControl("~/Pages /Usercontrols/ListGv/GvTop2000.ascx");
pnlGVList.ContentTemplateContainer.Controls.Add(usercontrol);
}
protected void btnTop2000_Click(object sender, EventArgs e) {
pnlGVList.ContentTemplateContainer.Controls.Clear();
GvTop2000 usercontrol = (GvTop2000)Page.LoadControl("~/Pages/Usercontrols/ListGv/GvTop2000.ascx");
pnlGVList.ContentTemplateContainer.Controls.Add(usercontrol);
pnlGVList.Update();
}
protected void btnNieuw_Click(object sender, EventArgs e) {
pnlGVList.ContentTemplateContainer.Controls.Clear();
GvNieuw usercontrol = (GvNieuw)Page.LoadControl("~/Pages/Usercontrols/ListGv/GvNieuw.ascx");
pnlGVList.ContentTemplateContainer.Controls.Add(usercontrol);
pnlGVList.Update();
}
list.aspx :
<asp:Content ID="ContentHolderDD" runat="server" ContentPlaceHolderID="ContentHolderDD">
<asp:ScriptManagerProxy ID="smProxy" runat="server" />
<%-- Year selector --%>
<asp:DropDownList ID="ddlJaar" CssClass="ddl" runat="server" DataSourceID="DSYears" DataTextField="top2000jaar" DataValueField="top2000jaar" AutoPostBack="True" />
<asp:SqlDataSource runat="server" ID="DSYears" ConnectionString='<%$ ConnectionStrings:TOP2000_IAO4A_GROEP2ConnectionString %>' SelectCommand="sp_get_year" SelectCommandType="StoredProcedure" />
</asp:Content>
<asp:Content ID="ContentPlaceholderButtons" runat="server" ContentPlaceHolderID="ContentPlaceholderButtons">
gvTop2000 usercontrol:
<%@ Control Language="C#" AutoEventWireup="true" CodeBehind="GvTop2000.ascx.cs" Inherits="Top2000.Pages.Usercontrols.ListGv.GvTop2000" %>
<asp:GridView runat="server" ID="gridList" CellPadding="10" ForeColor="#333333" GridLines="None" AutoGenerateColumns="False" DataSourceID="DSList" AllowPaging="True" PageSize="100" CssClass="GridListings">
<Columns>
<asp:BoundField DataField="positie" HeaderText="Positie" SortExpression="positie"></asp:BoundField>
<asp:HyperLinkField DataNavigateUrlFields="artiestid" DataNavigateUrlFormatString="Artists.aspx?id={0}" DataTextField="naam" HeaderText="Artiest" />
<asp:HyperLinkField DataNavigateUrlFields="songid" DataNavigateUrlFormatString="Song.aspx?id={0}" DataTextField="titel" HeaderText="Titel" />
<asp:BoundField DataField="jaar" HeaderText="Jaar" SortExpression="jaar"></asp:BoundField>
</Columns>
</asp:GridView>
<asp:SqlDataSource runat="server" ID="DSList" ConnectionString='<%$ ConnectionStrings:TOP2000_IAO4A_GROEP2ConnectionString %>' SelectCommand="sp_top2000_year" SelectCommandType="StoredProcedure" >
<SelectParameters>
<asp:ControlParameter PropertyName="SelectedValue" DefaultValue="" Name="YEAR" Type="Int32" ControlID="ContentHolderDD$ddlJaar" />
</SelectParameters>
</asp:SqlDataSource>
<asp:UpdatePanel runat="server" ID="pnlCButtons">
<ContentTemplate>
<asp:Button ID="btnTop2000" runat="server" Text="Top2000" OnClick="btnTop2000_Click" />
<asp:Button ID="btnNieuw" runat="server" Text="Nieuw" OnClick="btnNieuw_Click" />
</ContentTemplate>
</asp:UpdatePanel>
</asp:Content>
<asp:Content id="ContentPlaceHolder1" runat="server" ContentPlaceHolderID="ContentPlaceHolder1">
<%-- GridView --%>
<asp:UpdatePanel ID="pnlGVList" runat="server">
<ContentTemplate>
<asp:PlaceHolder runat="server" ID="phGv"/>
</ContentTemplate>
</asp:UpdatePanel>
gvNieuw usercontrol :
<%@ Control Language="C#" AutoEventWireup="true" CodeBehind="GvNieuw.ascx.cs" Inherits="Top2000.Pages.Usercontrols.ListGv.GvNieuw" %>
<asp:GridView runat="server" ID="gridList" CellPadding="10" ForeColor="#333333" GridLines="None" AutoGenerateColumns="False" DataSourceID="sqlDS" AllowPaging="True" PageSize="100" CssClass="GridListings" DataKeyNames="songid,top2000jaar,songid1,artiestid1">
<Columns>
<asp:BoundField DataField="songid" HeaderText="songid" SortExpression="songid" ReadOnly="True"></asp:BoundField>
<asp:BoundField DataField="top2000jaar" HeaderText="top2000jaar" SortExpression="top2000jaar" ReadOnly="True"></asp:BoundField>
<asp:BoundField DataField="positie" HeaderText="positie" SortExpression="positie" />
<asp:BoundField DataField="songid1" HeaderText="songid1" InsertVisible="False" ReadOnly="True" SortExpression="songid1" />
<asp:BoundField DataField="artiestid" HeaderText="artiestid" SortExpression="artiestid" />
<asp:BoundField DataField="titel" HeaderText="titel" SortExpression="titel" />
<asp:BoundField DataField="jaar" HeaderText="jaar" SortExpression="jaar" />
<asp:BoundField DataField="artiestid1" HeaderText="artiestid1" InsertVisible="False" ReadOnly="True" SortExpression="artiestid1" />
<asp:BoundField DataField="naam" HeaderText="naam" SortExpression="naam" />
</Columns>
</asp:GridView>
<asp:SqlDataSource ID="sqlDS" runat="server" ConnectionString="<%$ ConnectionStrings:TOP2000_IAO4A_GROEP2ConnectionString %>" SelectCommand="sp_new_songs_year" SelectCommandType="StoredProcedure">
<SelectParameters>
<asp:ControlParameter ControlID="ContentHolderDD$ddlJaar" Name="top2000Year" PropertyName="SelectedValue" Type="Int32" />
</SelectParameters>
</asp:SqlDataSource>