Hello,
I am attempting to to take edited values from a datagrid control and update
the underlying database. Problem is that some of the edited values don quite
seem to make it to my update sub. My code is shown below. The values that
are not appearing are Cell(4) - sCompletion and Cell(5) - sNote. The other
values show up just fine.
What am I missing here?
Bernard
Dim iLogID As String = Convert.ToStrin g(e.Item.Cells( 0).Text)
Dim sEntry As String = CType(e.Item.Ce lls(2).Controls (0), TextBox).Text
Dim sResp As String = CType(e.Item.Ce lls(3).Controls (1),
DropDownList).S electedItem.Val ue
Dim sCompletion As String = CType(e.Item.Ce lls(4).Controls (0), TextBox).Text
'Now.Date.ToStr ing
Dim sNote As String = CType(e.Item.Ce lls(5).Controls (0), TextBox).Text
If sNote = "" Then sNote = "*"
'Fill a string builder just to check values passed by DataGrid
Dim sb = New StringBuilder
sb.Append("LogI tem = " & iLogID)
sb.Append("; EntryDate: " & sEntry)
sb.Append("; Responsible: " & sResp)
sb.Append("; Completion Date: " & sCompletion)
sb.Append("; Note: " & sNote)
Label1.Text = sb.ToString
=============== =============== =============== =============== =============== =====
The DataGrid Code
=============== =============== =============== =============== =============== =====
<asp:datagrid id="DataGrid1" runat="server" ForeColor="Blac k"
BorderColor="#9 99999" BorderStyle="No ne"
BorderWidth="1p x" BackColor="Whit e" CellPadding="3"
GridLines="Vert ical" AutoGenerateCol umns="False">
<FooterStyle BackColor="#CCC CCC"></FooterStyle>
<SelectedItemSt yle Font-Bold="True" ForeColor="Whit e"
BackColor="#000 099"></SelectedItemSty le>
<AlternatingIte mStyle BackColor="#CCC CCC"></AlternatingItem Style>
<HeaderStyle Font-Bold="True" ForeColor="Whit e"
BackColor="Blac k"></HeaderStyle>
<Columns>
<asp:BoundColum n DataField="LogI D" ReadOnly="True"
HeaderText="Log ID"></asp:BoundColumn >
<asp:BoundColum n DataField="LogI tem" ReadOnly="True"
HeaderText="Log Item"></asp:BoundColumn >
<asp:BoundColum n DataField="LogD ate" HeaderText="Ent ry"
DataFormatStrin g="{0:MM-dd-yy}"></asp:BoundColumn >
<asp:TemplateCo lumn HeaderText="Res p">
<ItemTemplate >
<asp:Label runat="server" Text='<%# DataBinder.Eval (Container,
"DataItem.UserN ame") %>'>
</asp:Label>
</ItemTemplate>
<EditItemTempla te>
<asp:DropDownLi st id="UserIDList " runat="server" Datasource="<%#
GetUserIDList() %>" DataTextField=" UserName" DataValueField= "UserID" />
</EditItemTemplat e>
</asp:TemplateCol umn>
<asp:BoundColum n DataField="Comp letionDate" HeaderText="Com pleted"
DataFormatStrin g="{0:MM-dd-yy}"></asp:BoundColumn >
<asp:BoundColum n DataField="LogI temNote"
HeaderText="Not e"></asp:BoundColumn >
<asp:EditComman dColumn ButtonType="Lin kButton" UpdateText="Upd ate"
CancelText="Can cel" EditText="Edit" ></asp:EditCommand Column>
<asp:ButtonColu mn Text="Delete"
CommandName="De lete"></asp:ButtonColum n>
</Columns>
<PagerStyle HorizontalAlign ="Center" ForeColor="Blac k"
BackColor="#999 999"></PagerStyle>
</asp:datagrid>
