I have been pulling my hair out over this and have yet to find a resolution. The code was working until I changed the bound until I started tweaking the DataGrid.
The ASP page code is:
VB Code:
<asp:datagrid id="DataGrid1" runat="server" GridLines="Vertical" DataKeyField="City" AllowPaging="True" PageSize="6" BackColor="White" CellPadding="3" width="80%" BorderStyle="None" BorderWidth="1px" BorderColor="#999999" AutoGenerateColumns="False"> <SelectedItemStyle Font-Bold="True" ForeColor="White" BackColor="#008A8C"></SelectedItemStyle> <AlternatingItemStyle BackColor="Gainsboro"></AlternatingItemStyle> <ItemStyle ForeColor="Black" BackColor="#EEEEEE"></ItemStyle> <HeaderStyle Font-Bold="True" ForeColor="White" BackColor="#000084"></HeaderStyle> <FooterStyle ForeColor="Black" BackColor="#CCCCCC"></FooterStyle> <Columns> <asp:TemplateColumn> <ItemTemplate> <asp:LinkButton runat="server" Text="Edit" CommandName="Edit" CausesValidation="false"></asp:LinkButton> </ItemTemplate> <EditItemTemplate> <asp:LinkButton runat="server" Text="Update" CommandName="Update"></asp:LinkButton> <asp:LinkButton runat="server" Text="Cancel" CommandName="Cancel" CausesValidation="false"></asp:LinkButton> </EditItemTemplate> </asp:TemplateColumn> <asp:TemplateColumn> <ItemTemplate> <asp:LinkButton runat="server" Text="Delete" CommandName="Delete" CausesValidation="false"></asp:LinkButton> </ItemTemplate> </asp:TemplateColumn> <asp:TemplateColumn HeaderText="City"> <ItemTemplate> <asp:Label runat="server" Text='<%# DataBinder.Eval(Container, "DataItem.City") %>'> </asp:Label> </ItemTemplate> <EditItemTemplate> <asp:TextBox runat="server" Text='<%# DataBinder.Eval(Container, "DataItem.City") %>'> </asp:TextBox> </EditItemTemplate> </asp:TemplateColumn> <asp:TemplateColumn HeaderText="State/Country"> <ItemTemplate> <asp:Label runat="server" Text='<%# DataBinder.Eval(Container, "DataItem.State/Country") %>'> </asp:Label> </ItemTemplate> <EditItemTemplate> <asp:TextBox runat="server" Text='<%# DataBinder.Eval(Container, "DataItem.State/Country") %>'> </asp:TextBox> </EditItemTemplate> </asp:TemplateColumn> <asp:TemplateColumn HeaderText="Contact Email"> <ItemTemplate> <asp:Label runat="server" Text='<%# DataBinder.Eval(Container, "DataItem.Contact Email") %>'> </asp:Label> </ItemTemplate> <EditItemTemplate> <asp:TextBox runat="server" Text='<%# DataBinder.Eval(Container, "DataItem.Contact Email") %>'> </asp:TextBox> </EditItemTemplate> </asp:TemplateColumn> <asp:BoundColumn DataField="Active?" ReadOnly="True" HeaderText="Active?"></asp:BoundColumn> </Columns> <PagerStyle Font-Size="Smaller" HorizontalAlign="Center" ForeColor="Black" BackColor="#999999" Mode="NumericPages"></PagerStyle> </asp:datagrid>
The DataGrid_Update Sub line of code that blows up:
VB Code:
Was working before my changes to the Datagrids look and feel: Dim City As String = Server.UrlEncode(CType(E.Item.Cells(2).Controls(0), TextBox).Text) Tried this option as well: Dim city As TextBox = CType(E.Item.Cells(2).Controls(0), TextBox) Dim strcity As String = Server.UrlEncode(city.Text)
What am i doing wrong??![]()




Reply With Quote