Hi,
I am using gridview and sql datasource for select and update. When I
click on edit link against the records, the row is shows in edit mode.
When I make a change to it, the change is not updated and no errors
returned.
Here is the source.. Please help.
<asp:GridView ID="gvEvidence " runat="server" AllowPaging="Tr ue"
AllowSorting="T rue"
AutoGenerateCol umns="False" BackColor="Ligh tGoldenrodYello w"
BorderColor="Ta n"
BorderWidth="1p x" CellPadding="2" Font-Bold="False"
Font-Overline="False " Font-Size="1.25em" ForeColor="Blac k"
Width="100%" DataKeyNames="F rameworkEvidenc eId"
DataSourceID="D SEvidenceForAct ion">
<FooterStyle BackColor="Tan" Font-Size="1.2em" />
<Columns>
<asp:CommandFie ld ShowEditButton= "True" />
<asp:BoundFie ld DataField="Acti onMasterDisplay No"
HeaderText="Act ion No." SortExpression= "ActionMasterDi splayNo"
ReadOnly="True" />
<asp:BoundFie ld DataField="Acti onMasterDesc"
HeaderText="Act ion" SortExpression= "ActionMasterDe sc" ReadOnly="True"
/>
<asp:TemplateFi eld HeaderText="Ach ieved"
SortExpression= "FrameworkEvide nceAchieved"
ConvertEmptyStr ingToNull="Fals e">
<EditItemTempla te>
<asp:DropDownLi st ID="cboAchieved " runat="server"
SelectedValue=' <%# Bind("Framework EvidenceAchieve d") %>'>
<asp:ListItem Selected="True"
Value="yes">Yes </asp:ListItem>
<asp:ListItem Value="no">No</asp:ListItem>
<asp:ListItem Value="partial progress">Parti al
Progress</asp:ListItem>
<asp:ListItem Value="not applicable">Not
Applicable</asp:ListItem>
<asp:ListItem
Value="-">--Select--</asp:ListItem>
</asp:DropDownLis t>
</EditItemTemplat e>
<ItemTemplate >
<asp:Label ID="Label1" runat="server" Text='<%#
Bind("Framework EvidenceAchieve d") %>'></asp:Label>
</ItemTemplate>
</asp:TemplateFie ld>
<asp:TemplateFi eld HeaderText="Evi dence"
SortExpression= "FrameworkEvide nceDesc"
ConvertEmptyStr ingToNull="Fals e">
<EditItemTempla te>
<asp:TextBox ID="txtEvidence Desc" runat="server"
Text='<%# Bind("Framework EvidenceDesc") %>'
TextMode="Multi Line"></asp:TextBox>
</EditItemTemplat e>
<ItemTemplate >
<asp:Label ID="Label2" runat="server" Text='<%#
Bind("Framework EvidenceDesc") %>'></asp:Label>
</ItemTemplate>
</asp:TemplateFie ld>
<asp:TemplateFi eld HeaderText="Evi dence Ref"
SortExpression= "FrameworkEvide nceRef" ConvertEmptyStr ingToNull="Fals e">
<EditItemTempla te>
<asp:TextBox ID="txtEvidence Ref" runat="server"
MaxLength="150" Text='<%# Bind("Framework EvidenceRef")
%>'></asp:TextBox>
</EditItemTemplat e>
<ItemTemplate >
<asp:Label ID="Label3" runat="server" Text='<%#
Bind("Framework EvidenceRef") %>'></asp:Label>
</ItemTemplate>
</asp:TemplateFie ld>
<asp:TemplateFi eld HeaderText="Upd ated By"
SortExpression= "FrameworkEvide nceUpdatedBy"
ConvertEmptyStr ingToNull="Fals e">
<EditItemTempla te>
<asp:Labe l ID="lblUpdatedB y" runat="server"
Text="<%# GetLoggedInUser Id() %>"></asp:Label>
</EditItemTemplat e>
<ItemTemplate >
<asp:Label ID="Label4" runat="server" Text='<%#
Bind("Framework EvidenceUpdated By") %>'></asp:Label>
</ItemTemplate>
</asp:TemplateFie ld>
<asp:TemplateFi eld HeaderText="Dat e"
SortExpression= "FrameworkEvide nceUpdatedDate"
ConvertEmptyStr ingToNull="Fals e">
<EditItemTempla te>
<asp:Label ID="lblUpdatedD ate" runat="server"
Text="<%# now() %>"></asp:Label>
</EditItemTemplat e>
<ItemTemplate >
<asp:Label ID="Label5" runat="server" Text='<%#
Bind("Framework EvidenceUpdated Date") %>'></asp:Label>
</ItemTemplate>
</asp:TemplateFie ld>
</Columns>
<SelectedRowSty le BackColor="Dark SlateBlue"
ForeColor="Ghos tWhite" Font-Size="1.25em" />
<PagerStyle BackColor="Pale Goldenrod" ForeColor="Dark SlateBlue"
HorizontalAlign ="Center" />
<HeaderStyle BackColor="Tan" Font-Bold="True" />
<AlternatingRow Style BackColor="Pale Goldenrod" />
<EditRowStyle BackColor="Gold " BorderColor="Ho tTrack"
Font-Size="1.25em" />
<EmptyDataTempl ate>
Sorry, no data available.
</EmptyDataTempla te>
<EmptyDataRowSt yle Font-Size="1.25em" />
</asp:GridView>
<asp:SqlDataSou rce ID="DSEvidenceF orAction" runat="server"
ConnectionStrin g="<%$ ConnectionStrin gs:EqualitiesDb Conn %>"
SelectCommand=" ProcFrameworkEv idenceSelectALL ByDeptId"
SelectCommandTy pe="StoredProce dure" UpdateCommand=" UPDATE
dbo.FrameworkEv idence SET FrameworkEviden ceAchieved =
@evidenceAchiev ed, FrameworkEviden ceRef = @evidenceRef,
FrameworkEviden ceDesc = @evidenceDesc, FrameworkEviden ceUpdatedBy =
@updatedBy, FrameworkEviden ceUpdatedDate = @updatedDate WHERE
(FrameworkEvide nceId = @frameid)">
<SelectParamete rs>
<asp:Paramete r DefaultValue="3 " Name="dept_id" Type="Int64"
/>
</SelectParameter s>
<UpdateParamete rs>
<asp:Paramete r Name="evidenceA chieved" Type="String" />
<asp:Paramete r Name="evidenceR ef" Type="String" />
<asp:Paramete r Name="evidenceD esc" Type="String" />
<asp:Paramete r Name="updatedBy " Type="String" />
<asp:Paramete r Name="updatedDa te" Type="DateTime" />
<asp:Paramete r Name="frameid" Type="Int64" />
</UpdateParameter s>
</asp:SqlDataSour ce>
Thanks in advance!!
