How to add DataKeyField programatically

Vinod posted over 15 years ago

I would like to inject the primary key column dynamically into a grid and set the DataKeyField to it.

If I pre define the primary key column in a UltraWebGrid and set the DataKeyField to it at design time,

and in UpdateCell event if I access e.Cell.Row.DataKey everything is working fine.

If I try to add the primary key column in a UltraWebGrid and set the DataKeyField to it programatically,

e.Cell.Row.DataKey returns null. Is there another way to achive this, I mean using some other lifecycle

events..?

<igtbl:UltraWebGrid ID="uwgDepositList" runat="server" Height="134px" Width="400px"
        OnInitializeRow="uwgDepositList_InitializeRow" OnUpdateCell="uwgDepositList_UpdateCell"
        >
            <Bands>
                <igtbl:UltraGridBand BaseTableName="DepositItem" AllowUpdate="Yes">
                    <Columns>
                        <igtbl:UltraGridColumn BaseColumnName="GRID_KEY_ID" IsBound="True" Key="GRID_KEY_ID">
       <Header Caption="GRID_KEY_ID">
        <RowLayoutColumnInfo OriginX="1" />
       </Header>
       <Footer>
        <RowLayoutColumnInfo OriginX="1" />
       </Footer>
      </igtbl:UltraGridColumn>
      <igtbl:UltraGridColumn BaseColumnName="COL_UNBOUND" IsBound="True" Key="COL_UNBOUND">
       <Header Caption="COL_UNBOUND">
        <RowLayoutColumnInfo OriginX="1" />
       </Header>
       <Footer>
        <RowLayoutColumnInfo OriginX="1" />
       </Footer>
      </igtbl:UltraGridColumn>
                    </Columns>
                    <RowTemplateStyle BackColor="White" BorderColor="White" BorderStyle="Ridge">
                        <BorderDetails WidthBottom="3px" WidthLeft="3px" WidthRight="3px" WidthTop="3px" />
                    </RowTemplateStyle>
                    <AddNewRow View="NotSet" Visible="NotSet">
                    </AddNewRow>
                </igtbl:UltraGridBand>
            </Bands>
            <DisplayLayout BorderCollapseDefault="Separate" Name="uwgDepositList" RowHeightDefault="20px"
                StationaryMarginsOutlookGroupBy="True" TableLayout="Fixed" Version="4.00" AllowUpdateDefault="Yes"
                AutoGenerateColumns="False" CellClickActionDefault="Edit" RowSelectorsDefault="No">
                <FrameStyle BorderStyle="Solid" BorderWidth="1px" Font-Names="Verdana" Font-Size="8pt"
                    Height="134px" Width="400px">
                </FrameStyle>
                <RowAlternateStyleDefault BackColor="#FFFFC0">
                    <Padding Left="3px" />
                    <BorderDetails ColorLeft="255, 255, 192" ColorTop="255, 255, 192" />
                </RowAlternateStyleDefault>
                <EditCellStyleDefault BorderStyle="None" BorderWidth="0px">
                </EditCellStyleDefault>
                <FooterStyleDefault BackColor="LightGray" BorderStyle="Solid" BorderWidth="1px">
                    <BorderDetails ColorLeft="White" ColorTop="White" WidthLeft="1px" WidthTop="1px" />
                </FooterStyleDefault>
                <HeaderStyleDefault BackColor="LightGray" BorderStyle="Solid">
                    <BorderDetails ColorLeft="White" ColorTop="White" WidthLeft="1px" WidthTop="1px" />
                </HeaderStyleDefault>
                <RowStyleDefault BorderColor="Gray" BorderStyle="Solid" BorderWidth="1px" Font-Names="Verdana"
                    Font-Size="8pt">
                    <Padding Left="3px" />
                    <BorderDetails ColorLeft="White" ColorTop="White" />
                </RowStyleDefault>
                <AddNewBox>
                    <BoxStyle BackColor="LightGray" BorderStyle="Solid" BorderWidth="1px">
                        <BorderDetails ColorLeft="White" ColorTop="White" WidthLeft="1px" WidthTop="1px" />
                    </BoxStyle>
                </AddNewBox>
                <ActivationObject BorderColor="Black" BorderWidth="">
                </ActivationObject>
                <FilterOptionsDefault>
                    <FilterDropDownStyle BackColor="White" BorderColor="Silver" BorderStyle="Solid" BorderWidth="1px"
                        CustomRules="overflow:auto;" Font-Names="Verdana,Arial,Helvetica,sans-serif"
                        Font-Size="11px" Width="200px">
                        <Padding Left="2px" />
                    </FilterDropDownStyle>
                    <FilterHighlightRowStyle BackColor="#151C55" ForeColor="White">
                    </FilterHighlightRowStyle>
                    <FilterOperandDropDownStyle BackColor="White" BorderColor="Silver" BorderStyle="Solid"
                        BorderWidth="1px" CustomRules="overflow:auto;" Font-Names="Verdana,Arial,Helvetica,sans-serif"
                        Font-Size="11px">
                        <Padding Left="2px" />
                    </FilterOperandDropDownStyle>
                </FilterOptionsDefault>
            </DisplayLayout>
        </igtbl:UltraWebGrid>

private void Page_Load(object sender, EventArgs e)
{
InitData();
}

public void InitData(UltraWebGrid grid)
        {
            if (!IsPostBack)
            {

                //grid.Columns.Add(new UltraGridColumn("SEL", "", ColumnType.CheckBox, false))
                DataTable oDt = new DataTable("DepositItem");
                oDt.Columns.Add(new DataColumn("ROW_KEY", typeof (int)));
                oDt.Columns.Add(new DataColumn("GRID_KEY_ID", typeof (String)));
                oDt.Columns.Add(new DataColumn("COL_UNBOUND", typeof (String)));

                var row = oDt.NewRow();
                row["ROW_KEY"] = 111;
                row["GRID_KEY_ID"] = "1000";
                row["COL_UNBOUND"] = "1000Test";
                oDt.Rows.Add(row);
                row = oDt.NewRow();
                row["ROW_KEY"] = 222;
                row["GRID_KEY_ID"] = "2000";
                row["COL_UNBOUND"] = "2000Test";
                oDt.Rows.Add(row);
                grid.DataSource = oDt;
                grid.DataBind();
            }
        }

protected void uwgDepositList_UpdateCell(object sender, CellEventArgs e)
        {
            int i = 0;
        }

        protected void uwgDepositList_InitializeRow(object sender, RowEventArgs e)
        {
        }

105

Bert posted over 14 years ago in reply to Bert

Sorry about the spacing on that code example! I have no idea why it did that. I cut and pasted into the window from Visual Studio. :P I don't seem to be able to edit the post, or I would have fixed the spacing myself.
Cancel
Reply

Verify Answer

Cancel
105

Bert posted over 14 years ago in reply to [Infragistics] Vince McDonald

We are using the WebDataGrid and would also like to build the grid's data columns programatically as we would like to create some generic routines for handling mulitple tables. What I have so far is not quite working. I'm having trouble finding a code example of how to build a simple webdatagrid programmatically, assigning column editor providers, and allowing for adds, updates and deletes through the codebehind. What I have so far mostly works, but I get a DataKeyField issue when try to update a field and then do a postback. Can you provide a simple example of using programmatic building of edit providers that handle numeric, date, boolean, and text fields. This is what I have so far (please see included code below), but I can not get it to update, and realise I am missing at least one thing (maybe two, maybe three?). Thanks a lot for your help!

Private Sub
TestIGGV()

Try

Dim ds As
DataSet
ds = MySession.CC.FillDataSet(

"S_SYS_SearchForString"
, MySession.CC.Conn, MySession.TextValue, MySession.WhereClause)

'== IF DATA COLUMNS EXIST CREATE THE EDITOR PROVIDERS

If ds.Tables(0).Rows.Count > 0
Then

'== ENABLE CELL EDITING

Me.iggv.Behaviors.CreateBehavior(Of
EditingCore)()

Me.iggv.Behaviors.EditingCore.Behaviors.CreateBehavior(Of
CellEditing)()

'Me.iggv.Behaviors.CreateBehavior(Of Filtering)()

'Me.iggv.Behaviors.EditingCore.Behaviors.CellEditing.EditModeActions.MouseClick = EditMouseClickAction.Single

'== CREATE A DATA TABLE TO PREVENT CREATING THE PROVIDER MULTIPLE TIMES

Dim dtProviders As New
DataTable

Dim keys(0) As
DataColumn
dtProviders.Columns.Add(

"ID", System.Type.GetType("System.String"
))
keys(0) = dtProviders.Columns(

"ID"
)

'== SET THE PRIMARYKEY PROPERTY OF THE TABLE

dtProviders.PrimaryKey = keys

'== GET THE COLUMN TYPES

Dim dr As
DataRow
dr = ds.Tables(0).Rows(0)

Dim strProviderID As String =
Nothing

'== CREATE THE PROVIDERS

For intCounter As Integer = 0 To
ds.Tables(0).Columns.Count - 1

'== HAS A PROVIDER FOR THIS TYPE ALREADY BEEN CREATED

Dim foundRow As
DataRow = dtProviders.Rows.Find(dr.Item(intCounter).ToString)

If foundRow Is Nothing
Then

'== PREPARE A NEW ROW TO HOLD THE PROVIDER ID

Dim DataTypeName As String
= dr.Item(intCounter).GetType.ToString

Dim DataColumnName As String
= ds.Tables(0).Columns(intCounter).ToString

Dim columnSetting As New
EditingColumnSetting()

Dim drProviderName As
DataRow = dtProviders.NewRow()
drProviderName(

"ID"
) = DataColumnName

'== FOR EACH COLUMN THAT IS NOT NAMED "ID" BUT ENDS IN "ID" GET THE COLUMN NAME AND

' REFERENCE THE TABLE IT IS RELATED TO SO THAT WE CAN CREATE THE DATABOUND CONTROLS AND FILL THEM.

If DataColumnName <> "ID"
Then

If DataColumnName.Substring(DataColumnName.Length - 2) = "ID"
Then

Dim TableName As String = "REF_"
& DataColumnName.ToString.Substring(0, DataColumnName.Length - 2)

Dim StoredProcedureName As String = "S_"
& TableName

Dim dsDDL As
DataSet = MySession.CC.FillDataSet(StoredProcedureName, MySession.CC.Conn)

Dim ieProvider As DropDownProvider = New
DropDownProvider()
ieProvider.ID =

"iep_ddl"
& TableName
strProviderID = ieProvider.ID

'ieProvider.EditorControl.TextField = "Name"

'ieProvider.EditorControl.ValueField = "ID"

''bert'ieProvider.EditorControl.ID = "EditorControl" & intCounter

''bert'ieProvider.EditorControl.DisplayMode = DropDownDisplayMode.DropDownList

ieProvider.EditorControl.DropDownItemBinding.TextField =

"Name"

ieProvider.EditorControl.DropDownItemBinding.ValueField =

"ID"

ieProvider.EditorControl.DropDownOrientation = DropDownOrientation.Default

ieProvider.EditorControl.DropDownContainerWidth =

"250"

Dim ddl As WebDropDown = DirectCast
(ieProvider.GetEditor(), WebDropDown)
ddl.DataKeyFields =

"ID"

ddl.DataSource = dsDDL

ddl.DataBind()

ddl.ID =

"ddl_"
& TableName
ieProvider.GetEditor().ID = DataColumnName

columnSetting.ColumnKey = DataColumnName

columnSetting.EditorID = strProviderID

Me
.iggv.Behaviors.EditingCore.Behaviors.CellEditing.ColumnSettings.Add(columnSetting)

'== USE THE TABLE NAME TO GET THE DROPDOWNLIST DATA

Me
.iggv.EditorProviders.Add(ieProvider)

ElseIf IsNumeric(dr.Item(intCounter))
Then

Dim ieProvider As NumericEditorProvider = New
NumericEditorProvider()
ieProvider.ID =

"iep_Number"

strProviderID = ieProvider.ID

Me
.iggv.EditorProviders.Add(ieProvider)

'ElseIf IsDate(dr.Item(intCounter)) Then

' Dim ieProvider As DatePickerProvider = New DatePickerProvider()

' ieProvider.ID = "iep_Date"

' strProviderID = ieProvider.ID

' Me.iggv.EditorProviders.Add(ieProvider)

Else

Dim ieProvider As TextBoxProvider = New
TextBoxProvider
ieProvider.EditorControl.TextMode = TextBoxMode.MultiLine

ieProvider.EditorControl.CssClass =

"igg_EditTextArea"

ieProvider.ID =

"iep_Text"

strProviderID = ieProvider.ID

Me
.iggv.EditorProviders.Add(ieProvider)

End
If

End
If

'== HOOKS UP THE PROVIDER TO THE COLUMN BY KEY

If Not IsNumeric(dr.Item(intCounter)) And DataColumnName.Substring(DataColumnName.Length - 2) <> "ID"
Then

columnSetting.ColumnKey = ds.Tables(0).Columns(intCounter).ColumnName.ToString

columnSetting.EditorID = strProviderID

Me
.iggv.Behaviors.EditingCore.Behaviors.CellEditing.ColumnSettings.Add(columnSetting)

End
If

'== ADD THE TYPE TO THE LIST

dtProviders.Rows.Add(drProviderName)

End
If

Next

Me.iggv.DataKeyFields =
"ID"

Me
.iggv.DataSource = ds

Me
.iggv.DataBind()

End
If

Catch ex As
Exception
MySession.CC.HandleMessage(ex.Message,

Me
)

End
Try

End
Sub
Cancel
Reply

Verify Answer

Cancel
45049

Suggested Answer
[Infragistics] Vince McDonald posted over 15 years ago

When a grid's layout is being automaticalyl generated in this fashion, a good practice is to set the DataKeyField property on all of your grid's bands in the InitializeLayout event. This event occurs right after the call to DataBind() is made, and before the row objects are created.

I suspect that your issue is occuring because of how you're adding the column to your grid, assuming that you're doing this in the same way that you add the "SEL" column to your grid (which is commented out in your code snippet):
vinodres said:
//grid.Columns.Add(new UltraGridColumn("SEL", "", ColumnType.CheckBox, false))

This approach means that the column will not be stored in ViewState. Instead, you can use the following approach:

using Infragistics.WebUI.UltraWebGrid;
...
// Create the new column so that it is stored in ViewState
UltraGridColumn col = new UltraGridColumn(true);

// Set properties on the column
col.Key = "SEL";
col.Header.Caption = "";
col.Type = ColumnType.Checkbox;
col.DefaultValue = false;

// Add the column to the collection
grid.Columns.Add(col);
Cancel
Reply

Verify Answer

Reject Answer

Cancel