Edit/update i et Gridview
DavsFølgende bætte test gridview kan jeg ikke få til at virke!
Når jeg klikker "edit".....retter lidt i teksten.....klikker "update". Så står jeg tilbage med original gridviewet under rettelser i det.
Er der en der kan fortælle mig hvor det galt?
-----------------------------------------------------------
<asp:GridView ID="GridViewTESTER" AllowSorting="true" AllowPaging="true" Runat="server"
DataSourceID="SqlDataSourceTESTER" AutoGenerateEditButton="true" DataKeyNames="Navn"
AutoGenerateColumns="False">
<Columns>
<asp:BoundField HeaderText="Navn" DataField="Navn" SortExpression="Navn" />
<asp:BoundField HeaderText="MemoID" DataField="MemoID" SortExpression="MemoID" />
<asp:BoundField HeaderText="Email" DataField="Email" SortExpression="Email" />
<asp:BoundField HeaderText="Lokal" DataField="Lokal" SortExpression="Lokal" />
<asp:BoundField HeaderText="Mobil" DataField="Mobil" SortExpression="Mobil" />
<asp:BoundField HeaderText="Mobilnr" DataField="Mobilnr" SortExpression="Mobilnr" />
<asp:BoundField HeaderText="Privatnr" DataField="Privatnr" SortExpression="Privatnr" />
</Columns>
</asp:GridView>
<asp:SqlDataSource ID="SqlDataSourceTESTER" Runat="server" SelectCommand="SELECT [Navn], [MemoID], [Email], [Lokal], [Mobil], [Mobilnr], [Privatnr] FROM [Telefontavle]"
UpdateCommand="UPDATE [Telefontavle] SET [MemoID] = @MemoID, [Email] = @Email, [Lokal] = @Lokal, [Mobil] = @Mobil, [Mobilnr] = @Mobilnr, [Privatnr] = @Privatnr WHERE [Navn] = @Navn"
ConnectionString="<%$ ConnectionStrings:HotportalConnectionString %>" ProviderName="<%$ ConnectionStrings:HotportalConnectionString.ProviderName %>"/>
-----------------------------------------------------------
<configuration xmlns="http://schemas.microsoft.com/.NetConfiguration/v2.0">
<connectionStrings>
<add name="HotportalConnectionString" connectionString="Data Source=XXXXXXXXX;Initial Catalog=Hotportal;Password=XXXXX;User ID=XXXXX"
providerName="System.Data.SqlClient" />
<appSettings/>
