I am using gridview for the user to update rows. In a row, there sre
two columns, which need to be updated. When the gridview is to be
shown, the row should show the values from database. When user clicks
on edit link, should display the windows loginId in one column and in
second column, show the current datetime. When user clicks on update
link, should save these two column values to database as well as other
updated field values. I can't seem to find out how to set this up.
The Source doe is as follows:
<asp:GridView ID="gcEvidence " runat="server" AllowPaging="Tr ue"
AllowSorting="T rue"
AutoGenerateCol umns="False"
BackColor="Ligh tGoldenrodYello w" BorderColor="Ta n"
BorderWidth="1p x" CellPadding="2"
DataKeyNames="F rameworkEvidenc eId"
DataSourceID="D SFrameworkEvide nceSelectUpdate "
ForeColor="Blac k" GridLines="None " EmptyDataText=" Sorry, no
records found." Font-Italic="False" Font-Size="1.2em" Width="100%">
<FooterStyle BackColor="Tan" />
<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:BoundFie ld DataField="Fram eworkEvidenceId "
HeaderText="Fra meworkEvidenceI d"
InsertVisible=" False" ReadOnly="True"
SortExpression= "FrameworkEvide nceId" Visible="False" />
<asp:TemplateFi eld HeaderText="Evi dence Achieved"
SortExpression= "FrameworkEvide nceAchieved">
<EditItemTempla te>
<asp:DropDownLi st ID="cboAchieved "
runat="server" SelectedValue=' <%# Bind("Framework EvidenceAchieve d")
%>'>
<asp:ListItem
Value="-">--Select--</asp:ListItem>
<asp:ListItem
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: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 Ref"
SortExpression= "FrameworkEvide nceRef">
<EditItemTempla te>
<asp:TextBox ID="txtEvidence Ref" runat="server"
MaxLength="150" Text='<%# Bind("Framework EvidenceRef")
%>'></asp:TextBox>
</EditItemTemplat e>
<ItemTemplate >
<asp:Label ID="Label2" runat="server" Text='<%#
Bind("Framework EvidenceRef") %>'></asp:Label>
</ItemTemplate>
</asp:TemplateFie ld>
<asp:TemplateFi eld HeaderText="Evi dence Desc"
SortExpression= "FrameworkEvide nceDesc">
<EditItemTempla te>
<asp:TextBox ID="txtEvidence Desc"
runat="server" MaxLength="8000 " Text='<%# Bind("Framework EvidenceDesc")
%>'
TextMode="Multi Line"></asp:TextBox>
</EditItemTemplat e>
<ItemTemplate >
<asp:Label ID="Label3" runat="server" Text='<%#
Bind("Framework EvidenceDesc") %>'></asp:Label>
</ItemTemplate>
</asp:TemplateFie ld>
<asp:TemplateFi eld HeaderText="Upd ated By"
SortExpression= "FrameworkEvide nceUpdatedBy">
<EditItemTempla te>
<asp:TextBox ID="txtUpdatedB y" runat="server"
MaxLength="10" Text='<%# GetLoggedInUser Id() %>'
</asp:TextBox></EditItemTemplat e>
<ItemTemplate > <asp:Label
ID="Label5" runat="server" Text='<%# Bind("Framework EvidenceUpdated By")
%>'></asp:Label>
</ItemTemplate>
</asp:TemplateFie ld>
<asp:TemplateFi eld HeaderText="Dat e"
SortExpression= "FrameworkEvide nceUpdatedDate" >
<EditItemTempla te>
<asp:TextBox ID="txtDate" runat="server"
ReadOnly="True" Text='<%#
getCurrentDateT ime(Eval("Frame workEvidenceUpd atedDate"))
%>'></asp:TextBox>
</EditItemTemplat e>
<ItemTemplate >
<asp:Label ID="Label4" runat="server" Text='<%#
Bind("Framework EvidenceUpdated Date") %>'></asp:Label>
</ItemTemplate>
</asp:TemplateFie ld>
</Columns>
<SelectedRowSty le BackColor="Dark SlateBlue"
ForeColor="Ghos tWhite" />
<PagerStyle BackColor="Pale Goldenrod"
ForeColor="Dark SlateBlue" HorizontalAlign ="Center" />
<HeaderStyle BackColor="Tan" Font-Bold="True" />
<AlternatingRow Style BackColor="Pale Goldenrod" />
<EditRowStyle BackColor="#808 0FF" BorderColor="Bl ue"
Font-Size="1em" />
</asp:GridView>
<asp:SqlDataSou rce ID="DSFramework EvidenceSelectU pdate"
runat="server" ConnectionStrin g="<%$ ConnectionStrin gs:EqualitiesDb Conn
%>"
SelectCommand=" ProcFrameworkEv idenceSelectALL ByDeptId"
SelectCommandTy pe="StoredProce dure"
UpdateCommand=" ProcFrameworkEv idenceUpdate"
UpdateCommandTy pe="StoredProce dure">
<UpdateParamete rs>
<asp:Paramete r Name="Framework EvidenceId" />
<asp:Paramete r Name="Framework EvidenceDesc" />
<asp:Paramete r Name="Framework EvidenceRef" />
<asp:Paramete r Name="Framework EvidenceAchieve d" />
<asp:Paramete r Name="Framework EvidenceUpdated By" />
<asp:Paramete r Name="Framework EvidenceUpdated Date" />
</UpdateParameter s>
<SelectParamete rs>
<asp:Paramete r DefaultValue="3 " Name="dept_id"
Type="Int64" />
</SelectParameter s>
</asp:SqlDataSour ce>