ASP.NET Podcast Show #14 - Editable Datagrid
Subscribe
Download
Show Notes:
Julie Lerman or her blog at Ziff-Davis.
Doug Reilly.
Jason Salas.
Scott Mitchell.
Scott’s articles for creating an Editable Datagrid. Article 16 and Article 17.
ASP.NET Code:
<asp:DataGrid id="dgAction" runat="server" CssClass="form-label" Width="98%" AutoGenerateColumns="False"
UseAccessibleHeader="True" CellPadding="0" CellSpacing="0" BorderWidth="0">
<AlternatingItemStyle BackColor="Wheat"></AlternatingItemStyle>
<HeaderStyle BackColor="Silver"></HeaderStyle>
<Columns>
<asp:TemplateColumn HeaderText="Next Step">
<ItemTemplate>
<asp:TextBox Runat="server" ID="NextStep" Text='<%# Container.DataItem("NextStep")%>' cssclass="form-textbox" />
</ItemTemplate>
</asp:TemplateColumn>
<asp:TemplateColumn HeaderText="Due Date">
<ItemTemplate>
<ew:CalendarPopup id="dpDueDate" runat="server" selectedDate='<%# DisplayNullDate(Convert.ToString(Container.DataItem("DueDate")))%>' Nullable="True" NullableLabelText=" " cssclass="form-textbox" Width="75px" ToolTip="Open Calendar" DisableTextboxEntry="False" />
</ItemTemplate>
</asp:TemplateColumn>
<asp:TemplateColumn HeaderText="Completed Date">
<ItemTemplate>
<ew:CalendarPopup id="dpCompleteDate" runat="server" selectedDate='<%# DisplayNullDate(Convert.ToString(Container.DataItem("CompleteDate")))%>' Nullable="True" NullableLabelText=" " cssclass="form-textbox" Width="75px" ToolTip="Open Calendar" DisableTextboxEntry="False" />
</ItemTemplate>
</asp:TemplateColumn>
<asp:TemplateColumn HeaderText="Remove">
<ItemTemplate>
<asp:checkbox ID="cbRemoveAction" Runat="server" />
<asp:Label ID="lblActionId" Runat="server" Visible="false" Text='<%# Container.DataItem("tbActionId")%>' />
</ItemTemplate>
</asp:TemplateColumn>
</Columns>
</asp:DataGrid>
Binding the code:
Me.dgAction.DataSource = dtData
Me.dgAction.DataBind()
Finding controls:
For Each dgItem As DataGridItem In Me.dgAction.Items
strActionId = DirectCast(dgItem.FindControl("lblActionId"), System.Web.UI.WebControls.Label).Text
strAction = Trim(DirectCast(dgItem.FindControl("NextStep"), System.Web.UI.WebControls.TextBox).Text)
‘blah, blah, blah
Next
Getting the Drop Down ListBox
<asp:DropDownList Runat="server" ID="ddlTravelOfficeId" AutoPostBack="True" OnSelectedIndexChanged="ddlTravelOfficeId_SelectedIndexChanged"
CssClass="form-select" />
ASP.NET Code:
Protected Sub ddlTravelOfficeId_SelectedIndexChanged(ByVal sender As Object, ByVal e As EventArgs)
Dim strOfficeId As String
Dim ddlOcrOffice As DropDownList = DirectCast(sender, DropDownList)
Dim rpItem As RepeaterItem = DirectCast(ddlOcrOffice.Parent, RepeaterItem)
Dim ddlOcrStaff As DropDownList = DirectCast(rpItem.FindControl("ddlTravelOcrStaffId"), DropDownList)
strOfficeId = Convert.ToString(ddlOcrOffice.SelectedValue)
SetOfficeMembers(strOfficeId, ddlOcrStaff)
End Sub