UltraWebGrid Template editing | Infragistics Forums

Maya, below is what I have (it won't let me add an attachment). I have a couple of problems; 1) the edit template is aligned to the top of the row, not the bottom, which causes part of it to be off screen and it won't scroll up, 2) the dropdowns are not popluated. I followed your example, but I must not be doing something right. Please help. Also, how do I get the data from the controls in the edit template? Thanks

<igtbl:UltraWebGrid ID="igAction" runat="server" EnableAppStyling="True" StyleSetName="Office2007Blue"
StyleSetPath="~/ig_res/" DisplayLayout-CellPaddingDefault="5" OnUpdateRow="igActions_UpdateRow">
<Bands>
<igtbl:UltraGridBand>
<Columns>
<igtbl:UltraGridColumn BaseColumnName="ID" Key="ID"></igtbl:UltraGridColumn>
<igtbl:UltraGridColumn BaseColumnName="Process" Key="Process">
<Header>
<RowLayoutColumnInfo OriginX="2" />
</Header>
<Footer>
<RowLayoutColumnInfo OriginX="2" />
</Footer>
</igtbl:UltraGridColumn>
<igtbl:UltraGridColumn BaseColumnName="Action Item" Key="Action Item">
<Header>
<RowLayoutColumnInfo OriginX="3" />
</Header>
<Footer>
<RowLayoutColumnInfo OriginX="3" />
</Footer>
</igtbl:UltraGridColumn>
<igtbl:UltraGridColumn BaseColumnName="Action Type" Key="Action Type">
<Header>
<RowLayoutColumnInfo OriginX="4" />
</Header>
<Footer>
<RowLayoutColumnInfo OriginX="4" />
</Footer>
</igtbl:UltraGridColumn>
<igtbl:UltraGridColumn BaseColumnName="Status" Key="Status">
<Header>
<RowLayoutColumnInfo OriginX="5" />
</Header>
<Footer>
<RowLayoutColumnInfo OriginX="5" />
</Footer>
</igtbl:UltraGridColumn>
<igtbl:UltraGridColumn BaseColumnName="Assigned To" Key="Assigned To">
<Header>
<RowLayoutColumnInfo OriginX="6" />
</Header>
<Footer>
<RowLayoutColumnInfo OriginX="6" />
</Footer>
</igtbl:UltraGridColumn>
<igtbl:UltraGridColumn BaseColumnName="Due Date" Key="Due Date" Format="MM/dd/yyyy">
<Header>
<RowLayoutColumnInfo OriginX="7" />
</Header>
<Footer>
<RowLayoutColumnInfo OriginX="7" />
</Footer>
</igtbl:UltraGridColumn>
<igtbl:UltraGridColumn BaseColumnName="Completion Date" Key="Completion Date" Format="MM/dd/yyyy">
<Header>
<RowLayoutColumnInfo OriginX="8" />
</Header>
<Footer>
<RowLayoutColumnInfo OriginX="8" />
</Footer>
</igtbl:UltraGridColumn>
<igtbl:UltraGridColumn BaseColumnName="DATE" Key="DATE">
<Header>
<RowLayoutColumnInfo OriginX="9" />
</Header>
<Footer>
<RowLayoutColumnInfo OriginX="9" />
</Footer>
</igtbl:UltraGridColumn>
</Columns>
<RowEditTemplate>
<p align="left">
<asp:DropDownList ID="ddlActionProcess" runat="server" columnkey="Process"
DataTextField="Process" OnInit="ddlActionProcess_Init">
</asp:DropDownList>
<input id="txtActionItem" columnkey="Action Item" style="width:150px;" type="text" />
<asp:DropDownList ID="ddlActionItem" runat="server" columnkey="Action Item" DataTextField="Action Item"
OnInit="ddlActionItem_Init">
</asp:DropDownList>
<asp:DropDownList ID="ddlActionStatus" runat="server" columnkey="Status" DataTextField="Status"
OnInit="ddlActionStatus_Init">
</asp:DropDownList>
<input id="txtActionAssignedTo" columnkey="Assigned To" style="width: 100px;" type="text" />
<igsch:WebDateChooser ID="igActionDueDate" columnkey="Due Date" runat="server"
NullDataLabel="Select a Date" Format="Short" OnInit="igActionDueDate_Init">
</igsch:WebDateChooser>
<igsch:WebDateChooser ID="igActionCompletionDate" columnkey="Completion Date" runat="server" NullDataLabel="Select a Date"
Format="Short" OnInit="igActionCompletionDate_Init">
</igsch:WebDateChooser>
<igsch:WebDateChooser ID="igActionDate" columnkey="DATE" runat="server"
NullDataLabel="Select a Date" Format="Short" OnInit="igActionDate_Init">
</igsch:WebDateChooser>
<br /><br />
</p>
<br />
<p align="center" >
<input id="igAction_reOkBtn" onclick="igAction_gRowEditButtonClick(event);" style="width: 50px;"
type="button" value="OK">  
<input id="igAction_reCancelBtn" onclick="igAction_gRowEditButtonClick(event);" style="width: 50px;"
type="button" value="Cancel"> </input>
</input>
</p>
</RowEditTemplate>
<AddNewRow View="NotSet" Visible="NotSet">
</AddNewRow>
</igtbl:UltraGridBand>
</Bands>
<DisplayLayout Name="igAction" AllowDeleteDefault="Yes" AllowSortingDefault="No" AllowUpdateDefault="RowTemplateOnly"
BorderCollapseDefault="Separate" CellPaddingDefault="5" AutoGenerateColumns="false" RowSelectorsDefault="No"
RowHeightDefault="20px" Version="4.00" CellClickActionDefault="Edit" SelectTypeRowDefault="Extended"
StationaryMargins="Header" TableLayout="Fixed" >
<FrameStyle>
</FrameStyle>
<ActivationObject BorderColor="" BorderWidth="">
</ActivationObject>
</DisplayLayout>
</igtbl:UltraWebGrid>

********************************************************

Imports System
Imports System.Data
Imports System.Data.SqlClient
Imports System.Collections.Generic
Imports System.Web
Imports System.Web.UI
Imports System.Web.UI.WebControls
Imports Infragistics
Imports Infragistics.WebUI
Imports Infragistics.WebUI.UltraWebGrid
Imports Infragistics.WebUI.WebSchedule

Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
SetSubtitle()
If Not IsPostBack Then
Response.Cache.SetNoServerCaching()
Response.Cache.SetCacheability(HttpCacheability.NoCache)
ClearCache()
LoadData()
End If

End Sub

Private Sub LoadData()
Dim ds As New DataSet
Try
ds = GetActionDataSet()
igAction.DataSource = ds
igAction.DataBind()
Catch ex As Exception
End Try
End Sub

Protected Sub igActionProcess_Init(ByVal sender As Object, ByVal e As EventArgs)
Try
Dim d As DropDownList = DirectCast(sender, DropDownList)
Dim ds As New DataSet

ds = GetDataSet("processes)
If IsDatasetValid(ds) Then
d.DataSource = ds
d.DataBind()
End If
Catch ex As Exception
End Try
End Sub

Protected Sub igActionType_Init(ByVal sender As Object, ByVal e As EventArgs)
Dim d As DropDownList = DirectCast(sender, DropDownList)
Dim ds As New DataSet

Try
Try
ds = GetDataSet("actiontypelist")
If IsDatasetValid(ds) Then
d.DataSource = ds
d.DataBind()
End If
Catch ex As Exception
End Try
Catch ex As Exception
End Try
End Sub

Protected Sub igActionStatus_Init(ByVal sender As Object, ByVal e As EventArgs)
Dim d As DropDownList = DirectCast(sender, DropDownList)
Dim ds As New DataSet

Try
Try
ds = GetDataSet("statuslist")
If IsDatasetValid(ds) Then
d.DataSource = ds
d.DataBind()
End If
Catch ex As Exception
End Try
Catch ex As Exception
End Try
End Sub

Protected Sub igActionDueDate_Init(ByVal sender As Object, ByVal e As EventArgs)
Try
Dim c As WebDateChooser = DirectCast(sender, WebDateChooser)
c.Format = DateFormat.Short
Catch ex As Exception
End Try
End Sub

Protected Sub igActionCompletionDate_Init(ByVal sender As Object, ByVal e As EventArgs)
Try
Dim c As WebDateChooser = DirectCast(sender, WebDateChooser)
c.Format = DateFormat.Short
Catch ex As Exception
End Try
End Sub

Protected Sub igActionDate_Init(ByVal sender As Object, ByVal e As EventArgs)
Try
Dim c As WebDateChooser = DirectCast(sender, WebDateChooser)
c.Format = DateFormat.Short
Catch ex As Exception
End Try
End Sub

Protected Sub igAction_UpdateRow(ByVal sender As Object, ByVal e As Infragistics.WebUI.UltraWebGrid.RowEventArgs)

End Sub

Maya, Thanks. I will look at this soon. I have a different problem that has shown up. I have two date fields in my grid, when I click to edit, the template has the first date in both date controls. When I stop through in the code behind where I set them, like in your example, the set correctly. But once it displays, both date controls have the date of the first control. One is named date and the other is completeddate, both controls have the date value. LIke I said, when i stop through, the dates are set appropriately, but somewhere my completeddate control is being over written with the date control value. My html & code are below. I though I must be referencing the wrong cell somehow, but it appears to be the correct cell. I'm mystified. Thanks.

        <igtbl:UltraWebGrid ID="igGrid" runat="server" EnableAppStyling="True" StyleSetName="Office2007Blue"
            StyleSetPath="~/ig_res/" DisplayLayout-CellPaddingDefault="5">
            <Bands>
                <igtbl:UltraGridBand>
                    <Columns>
                        <igtbl:UltraGridColumn BaseColumnName="ID" Key="ID" Hidden="true">
                        </igtbl:UltraGridColumn>
                        <igtbl:UltraGridColumn BaseColumnName="DATE" Key="DATE">
                            <Header Caption="Due Date">
                                <RowLayoutColumnInfo OriginX="2" />
                            </Header>
                            <HeaderStyle HorizontalAlign="Center" />
                            <CellStyle HorizontalAlign="Center" />
                            <Footer>
                                <RowLayoutColumnInfo OriginX="2" />
                            </Footer>
                        </igtbl:UltraGridColumn>
                        <igtbl:UltraGridColumn BaseColumnName="NAME" Key="NAME">
                            <Header Caption="Name">
                                <RowLayoutColumnInfo OriginX="3" />
                            </Header>
                            <HeaderStyle HorizontalAlign="Left" />
                            <CellStyle HorizontalAlign="Left" />
                            <Footer>
                                <RowLayoutColumnInfo OriginX="3" />
                            </Footer>
                        </igtbl:UltraGridColumn>
                        <igtbl:UltraGridColumn BaseColumnName="Analysis" Key="Analysis">
                            <Header Caption="Analysis">
                                <RowLayoutColumnInfo OriginX="4" />
                            </Header>
                            <HeaderStyle HorizontalAlign="Left" />
                            <CellStyle HorizontalAlign="Left" />
                            <Footer>
                                <RowLayoutColumnInfo OriginX="4" />
                            </Footer>
                        </igtbl:UltraGridColumn>
                        <igtbl:UltraGridColumn BaseColumnName="STATUS" Key="STATUS">
                            <Header Caption="Status">
                                <RowLayoutColumnInfo OriginX="5" />
                            </Header>
                            <HeaderStyle HorizontalAlign="Center" />
                            <CellStyle HorizontalAlign="Center" />
                            <Footer>
                                <RowLayoutColumnInfo OriginX="5" />
                            </Footer>
                        </igtbl:UltraGridColumn>
                        <igtbl:UltraGridColumn BaseColumnName="GOALDESC" Key="GOALDESC">
                            <Header Caption="Goal">
                                <RowLayoutColumnInfo OriginX="6" />
                            </Header>
                            <HeaderStyle HorizontalAlign="Center" />
                            <CellStyle HorizontalAlign="Center" />
                            <Footer>
                                <RowLayoutColumnInfo OriginX="6" />
                            </Footer>
                        </igtbl:UltraGridColumn>
                        <igtbl:UltraGridColumn BaseColumnName="COMPLETEDDATE" Key="COMPLETEDDATE">
                            <Header Caption="Completed">
                                <RowLayoutColumnInfo OriginX="7" />
                            </Header>
                            <HeaderStyle HorizontalAlign="Center" />
                            <CellStyle HorizontalAlign="Center" />
                            <Footer>
                                <RowLayoutColumnInfo OriginX="7" />
                            </Footer>
                        </igtbl:UltraGridColumn>
                    </Columns>
                    <RowEditTemplate>
                        <div id="divGridControls" style="background-color: #E5ECFD;">
                            <p align="left" style="padding: 2px 2px 2px 2px; border-color: Lightgray; border-width: 1px;
                                border-style: solid;">
                                <asp:Table ID="tblGridControls" runat="server">
                                    <asp:TableRow Visible="false">
                                        <asp:TableCell ColumnSpan="2">
                                            <asp:Label ID="lblGridID" runat="server" columnkey="ID"></asp:Label>
                                        </asp:TableCell>
                                    </asp:TableRow>
                                    <asp:TableRow>
                                        <asp:TableCell Width="85px">
                                            <asp:label ID="lblGridDueDate" runat="server">Due Date</asp:label>
                                        </asp:TableCell>
                                        <asp:TableCell>
                                            <igsch:WebDateChooser ID="igGridDueDate" columnkey="DATE" runat="server"
                                                EnableAppStyling="True" Section508Compliant="true" StyleSetName="Office2007Blue"
                                                StyleSetPath="~/ig_res/" NullDateLabel="Select a Date" AllowNull="true" Format="Short">
                                            </igsch:WebDateChooser>
                                        </asp:TableCell>
                                    </asp:TableRow>
                                    <asp:TableRow>
                                        <asp:TableCell>
                                            <asp:Label ID="lblGridItem" runat="server">Name</asp:Label>
                                        </asp:TableCell>
                                        <asp:TableCell>
                                            <asp:TextBox ID="txtGridItem" runat="server" TextMode="MultiLine" Rows="3" MaxLength="10000"
                                                ToolTip="10,000 Maximum Characters" Width="850px" columnkey="NAME"></asp:TextBox>
                                        </asp:TableCell>
                                    </asp:TableRow>
                                    <asp:TableRow>
                                        <asp:TableCell>
                                            <asp:Label ID="lblGridAnalysis" runat="server">Analysis</asp:Label>
                                        </asp:TableCell>
                                        <asp:TableCell>
                                            <asp:TextBox ID="txtGridAnalysis" runat="server" TextMode="MultiLine" Rows="3" MaxLength="10000"
                                                ToolTip="10,000 Maximum Characters" Width="850px" columnkey="ANALYSIS"></asp:TextBox>
                                        </asp:TableCell>
                                    </asp:TableRow>
                                    <asp:TableRow>
                                        <asp:TableCell>
                                            <asp:Label ID="lblGridStatus" runat="server">Status</asp:Label>
                                        </asp:TableCell>
                                        <asp:TableCell>
                                            <asp:DropDownList ID="ddlGridStatus" runat="server" columnkey="STATUS" DataTextField="STATUS"
                                                Width="150px">
                                            </asp:DropDownList>
                                        </asp:TableCell>
                                    </asp:TableRow>
                                    <asp:TableRow>
                                        <asp:TableCell>
                                            <asp:Label ID="lblGridGoal" runat="server">Goal in AFS Plan</asp:Label>
                                        </asp:TableCell>
                                        <asp:TableCell>
                                            <asp:DropDownList ID="ddlGridGoal" runat="server" columnkey="GOALDESC" DataTextField="GOALDESC"
                                                Width="150px">
                                            </asp:DropDownList>
                                        </asp:TableCell>
                                    </asp:TableRow>
                                    <asp:TableRow>
                                        <asp:TableCell>
                                            <asp:Label ID="lblGridCompletedDate" runat="server">Completed</asp:Label>
                                        </asp:TableCell>
                                        <asp:TableCell>
                                            <igsch:WebDateChooser ID="igGridCompletedDate" columnkey="COMPLETEDDATE"
                                                runat="server" EnableAppStyling="True" Section508Compliant="true" StyleSetName="Office2007Blue"
                                                StyleSetPath="~/ig_res/" NullDateLabel="Select a Date" AllowNull="true" Format="Short">
                                            </igsch:WebDateChooser>
                                        </asp:TableCell>
                                    </asp:TableRow>
                                </asp:Table>
                            </p>
                            <p align="center" style="background-color: #D5DDEA; vertical-align: middle; padding: 2px 2px 0px 2px;
                                border-color: Gray; border-width: 1px; border-style: solid;">
                                <asp:ImageButton ID="ibtnGridOK" runat="server" ImageUrl="~/Images/oknew.png"
                                    OnClick="ibtnGridOK_Click" />
                                <asp:ImageButton ID="ibtnGridCancel" runat="server" ImageUrl="~/Images/cancelnew.png" />
                            </p>
                        </div>
                    </RowEditTemplate>
                    <RowTemplateStyle Wrap="true">
                    </RowTemplateStyle>
                    <AddNewRow View="Bottom" Visible="Yes">
                    </AddNewRow>
                </igtbl:UltraGridBand>
            </Bands>
            <DisplayLayout Name="igGrid" AllowDeleteDefault="Yes" AllowSortingDefault="No" AllowUpdateDefault="RowTemplateOnly"
                BorderCollapseDefault="Separate" CellPaddingDefault="5" AutoGenerateColumns="false"
                RowSelectorsDefault="Yes" RowHeightDefault="20px" NoDataMessage="No Performance Plan Items To Display"
                Version="4.00" CellClickActionDefault="Edit" SelectTypeRowDefault="Single" AllowAddNewDefault="Yes">
                <FrameStyle>
                </FrameStyle>
                <ActivationObject BorderColor="" BorderWidth="">
                </ActivationObject>
            </DisplayLayout>
        </igtbl:UltraWebGrid>

    Protected Sub igGrid_InitializeLayout(ByVal sender As Object, ByVal e As Infragistics.WebUI.UltraWebGrid.LayoutEventArgs) Handles igGrid.InitializeLayout
        Try
            SetGridControls()
        Catch ex As Exception
        End Try
        With e.Layout.Bands(0).Columns.FromKey("DATE")
            .Header.Caption = "Due Date"
            .DataType = "System.DateTime"
            .Format = "MM/dd/yyyy"
            .Header.Style.HorizontalAlign = HorizontalAlign.Center
            .CellStyle.HorizontalAlign = HorizontalAlign.Center
        End With
        With e.Layout.Bands(0).Columns.FromKey("NAME")
            .Header.Caption = "Performance Plan Goal"
            .Header.Style.HorizontalAlign = HorizontalAlign.Left
            .CellStyle.HorizontalAlign = HorizontalAlign.Left
            .CellStyle.Wrap = True
            .Width = Unit.Pixel(450)
        End With
        With e.Layout.Bands(0).Columns.FromKey("Analysis")
            .Header.Caption = "Analysis"
            .Header.Style.HorizontalAlign = HorizontalAlign.Left
            .CellStyle.HorizontalAlign = HorizontalAlign.Left
            .CellStyle.Wrap = True
            .Width = Unit.Pixel(650)
        End With
        With e.Layout.Bands(0).Columns.FromKey("COMPLETEDDATE")
            .Header.Caption = "Completed Date"
            .DataType = "System.DateTime"
            .Format = "MM/dd/yyyy"
            .Header.Style.HorizontalAlign = HorizontalAlign.Center
            .CellStyle.HorizontalAlign = HorizontalAlign.Center
        End With
    End Sub

    Protected Sub igGrid_InitializeRow(ByVal sender As Object, ByVal e As Infragistics.WebUI.UltraWebGrid.RowEventArgs) Handles igGrid.InitializeRow
        Dim lGridID As Label = igGrid.Bands(0).RowEditItem.FindControl("lblGridID")
        Dim dtDueDate As Infragistics.WebUI.WebSchedule.WebDateChooser = igGrid.Bands(0).RowEditItem.FindControl("igGridDueDate")
        Dim dtCompletedDate As Infragistics.WebUI.WebSchedule.WebDateChooser = igGrid.Bands(0).RowEditItem.FindControl("igGridCompletedDate")

        If Not IsNothing(lGridID) Then
            lGridID.Text = e.Row.Cells(0).Text
        End If
        If IsDate(e.Row.Cells(1).Text) = True Then
            If CDate(e.Row.Cells(1).Text) <= CDate("1/1/2000") Then
                e.Row.Cells(1).Text = " "
                dtDueDate.Value = ""
            Else
                dtDueDate.Value = CDate(e.Row.Cells(1).Text)
            End If
        Else
            dtDueDate.Value = " "
        End If
        If IsDate(e.Row.Cells(6).Text) = True Then
            If CDate(e.Row.Cells(6).Text) <= CDate("1/1/2000") Then
                e.Row.Cells(6).Text = " "
                dtCompletedDate.Value = ""
            Else
                dtCompletedDate.Value = CDate(e.Row.Cells(6).Text)
            End If
        Else
            dtCompletedDate.Value = " "
        End If

    End Sub

   Private Sub SetGridControls()
        Dim Profile() As String = GetUserProfile(GetUser(Page.User.Identity.Name))
        Dim officename As String = GetOfficeName(Profile)
        Dim ddlGridStatus As DropDownList = igGrid.Bands(0).RowEditItem.FindControl("ddlGridStatus")
        Dim ddlGridGoal As DropDownList = igGrid.Bands(0).RowEditItem.FindControl("ddlGridGoal")
        Dim ds As New DataSet
        Dim Choice As String = String.Empty

        'Status List
        Try
            Choice = "statuslist"
            ds = GetDataSet(Choice)
            If IsDatasetValid(ds) Then
                ddlGridStatus.DataSource = ds
                ddlGridStatus.DataBind()
            End If
        Catch ex As Exception
        End Try
        'goal List
        Try
            Choice = "perfgoallist"
            ds = GetDataSet(Choice)
            If IsDatasetValid(ds) Then
                ddlGridGoal.DataSource = ds
                ddlGridGoal.DataBind()
            End If
        Catch ex As Exception
        End Try
    End Sub