I have 2 datagrids, both with databound columns that I have dynamically
added. I have an EditCommandColu mn on both grids. EnableViewState is
enabled on both of the grids.
When I click the edit link on the grids I need to repopulate/rebind the
grids which I presume is correct.
When I click the update button I cannot find my databound columns that I
have edited. I have searched google and tried all the obvious examples, but
I am just not getting it. Is there perhaps a bug, or a limitation with
having 2 grids on one page. What exactly does EnableViewState do anyway if
it doesn't retain the data or already loaded in the grids? Here is my code
for populating one of the grids - the other is very similiar. If anyone has
any idea then please let me know as I am really stuck now...
Page Load....
dgPhotos.AutoGe nerateColumns = False
If dgPhotos.Column s.Count = 5 Then
' Create ID column & add to DataGrid
Dim col1 As New BoundColumn
col1.HeaderText = "Descriptio n"
col1.DataField = "PhotoText"
dgPhotos.Column s.Add(col1)
col1 = Nothing
Dim col2 As New BoundColumn
col2.HeaderText = "Filename"
col2.DataField = "Filename"
col2.ReadOnly = True
dgPhotos.Column s.Add(col2)
col2 = Nothing
Dim col3 As New BoundColumn
col3.HeaderText = "Order"
col3.DataField = "OrderPos"
col3.ReadOnly = True
col3.Visible = False
dgPhotos.Column s.Add(col3)
col3 = Nothing
End If
dsPhotos.ReadXm l(filePath)
dgPhotos.Visibl e = False
If dsPhotos.Tables .Count > 0 Then
dgPhotos.Visibl e = True
Dim lngID As Long
lngID = GetAlbumID(dsPh otos, strRoleID)
dvPhotos.Table = dsPhotos.Tables (1)
dvPhotos.RowFil ter = "AlbumRoleI D_Id = '" & lngID & "'"
dvPhotos.Sort = "OrderPos"
With dgPhotos
.DataSource = dvPhotos
.DataMember = "PhotoItem"
.DataBind()
End With
End If
Editing Code:
Private Sub dgPhotos_EditCo mmand(ByVal source As Object, ByVal e As
System.Web.UI.W ebControls.Data GridCommandEven tArgs) Handles
dgPhotos.EditCo mmand
dgPhotos.EditIt emIndex = e.Item.ItemInde x
Dim strRoleID As String
PopulateGrid() 'Rebinds also
End Sub
Update Code so far :
Private Sub dgPhotos_Update Command(ByVal source As Object, ByVal e As
System.Web.UI.W ebControls.Data GridCommandEven tArgs) Handles
dgPhotos.Update Command
Dim txtDescription As New TextBox
txtDescription = CType(e.Item.Ce lls(1).FindCont rol("PhotoText" ),
TextBox)
End Sub
aspx...
<asp:datagrid id="dgPhotos" runat="server" CssClass="aspTa ble"
ForeColor="Blac k" Font-Size="XX-Small"
AutoGenerateCol umns="False" PageSize="15" Width="100%"
CellSpacing="2" AllowPaging="Tr ue" BorderColor="#9 99999"
BorderStyle="So lid" BorderWidth="3p x" BackColor="#CCC CCC"
CellPadding="4" >
<SelectedItemSt yle Font-Size="XX-Small" Font-Bold="True"
ForeColor="Whit e" BackColor="#000 099"></SelectedItemSty le>
<EditItemStyl e Font-Size="XX-Small"></EditItemStyle>
<AlternatingIte mStyle Font-Size="XX-Small"></AlternatingItem Style>
<ItemStyle Font-Size="XX-Small" BackColor="Whit e"></ItemStyle>
<HeaderStyle Font-Size="XX-Small" Font-Bold="True" ForeColor="Whit e"
BackColor="Blac k"></HeaderStyle>
<FooterStyle Font-Size="XX-Small" BackColor="#CCC CCC"></FooterStyle>
<Columns>
<asp:ButtonColu mn Text="Up" ButtonType="Pus hButton"
CommandName="Up "></asp:ButtonColum n>
<asp:ButtonColu mn Text="Down" ButtonType="Pus hButton"
CommandName="Do wn"></asp:ButtonColum n>
<asp:EditComman dColumn ButtonType="Lin kButton" UpdateText="Upd ate"
CancelText="Can cel" EditText="Edit" >
<HeaderStyle Font-Size="XX-Small"></HeaderStyle>
<ItemStyle Font-Size="XX-Small"></ItemStyle>
<FooterStyle Font-Size="XX-Small"></FooterStyle>
</asp:EditCommand Column>
<asp:ButtonColu mn Text="Delete" CommandName="De lete">
<HeaderStyle Font-Size="XX-Small"></HeaderStyle>
<ItemStyle Font-Size="XX-Small"></ItemStyle>
<FooterStyle Font-Size="XX-Small"></FooterStyle>
</asp:ButtonColum n>
<asp:TemplateCo lumn HeaderText="Pho to">
<ItemTemplate >
<asp:Image runat=server
ImageUrl='<%#Re turnSmallURL(Da taBinder.Eval(c ontainer.datait em, "filename") ,
dgAlbums.Items( dgAlbums.Select edIndex).Cells. Item(7).Text)%> ' ID="Image2"/>
</ItemTemplate>
</asp:TemplateCol umn>
</Columns>
<PagerStyle Font-Size="XX-Small" HorizontalAlign ="Left"
ForeColor="Blac k" BackColor="#CCC CCC"
Mode="NumericPa ges"></PagerStyle>
</asp:datagrid>
