This is a migrated thread and some comments may be shown as answers.

Dynamically assign/change datakeynames to RadGrid

9 Answers 1230 Views

Grid

This is a migrated thread and some comments may be shown as answers.

9 Answers, 1 is accepted

answered on 27 Aug 2015, 05:03 PM

Hi Eyup,

In my scenario, column structure of the grids is constant. I am trying to change the datakeynames assigned to both mastertable and detailtable dynamically based on user selection. I am trying the following procedure. Please let me know if I am approaching in correct way.

In aspx file , I declared the grid and their columns statically as below

<t:RadGrid ID="rgLEV" runat="server" Width="1200px" AllowSorting="True" GridLines="None" ShowFooter="True" AutoGenerateColumns="False" EnableViewState= "false" AutoGenerateHierarchy="false" Skin="Web20" CssClass="rgDataDiv"
GroupingEnabled="true" ShowGroupPanel="true" OnGroupsChanging="rgLEV_GroupsChanging" AllowMultiRowSelection="true"
HeaderStyle-Wrap="false" ItemStyle-Wrap="false"

OnNeedDataSource="rgLEV_NeedDataSource"
OnPreRender="rgLEV_PreRender"
OnItemCommand="rgLEV_ItemCommand"
OnUpdateCommand="rgLEV_UpdateCommand"
OnItemCreated="rgLEV_ItemCreated"
OnDetailTableDataBind="rgLEV_DetailTableDataBind"
OnItemDataBound="rgLEV_ItemDataBound"
OnExportCellFormatting="rgLEV_ExportCellFormatting" >
<ClientSettings AllowDragToGroup="True" AllowColumnsReorder="True"
ReorderColumnsOnClient="True">
<Selecting AllowRowSelect="true" EnableDragToSelectRows="true" />
</ClientSettings>

<GroupingSettings RetainGroupFootersVisibility="true"/>
<MasterTableView Name="MasterTableView" AutoGenerateColumns="false" EnableColumnsViewState="false" EditMode="EditForms" CommandItemDisplay="Top" NoMasterRecordsText="No records to display."
ExpandCollapseColumn-ButtonType="ImageButton" ShowGroupFooter="true"
ExpandCollapseColumn-CollapseImageUrl="Images/SingleMinus.gif" ExpandCollapseColumn-ExpandImageUrl="Images/SinglePlus.gif"
HierarchyLoadMode="ServerOnDemand" ExpandCollapseColumn-HeaderButtonType="LinkButton" GroupLoadMode="Client">
<CommandItemTemplate>
<div> ........ </div>
</CommandItemTemplate>

<Columns> ........ </Columns>

</RadGrid>

---------------------------------------------------------------------------------------------------------

And in code behind,

I am assigning datakeynames dynamically in Page_Init() like you said. and accessing the datakeynames in DetailTableDataBind().

protected void Page_Init(object sender, EventArgs e)
{
if (!IsPostBack)
{
GridTableView gtv = rgLEV.MasterTableView.DetailTables[0];
GridRelationFields relationField2 = new GridRelationFields();
if (Version >= 15)
{

rgLEV.MasterTableView.DataKeyNames = new string[] { "LABOR_IDENT, LD_STATUS" };
gtv.DataKeyNames = new string[] { "LABOR_IDENT, LD_STATUS" };
GridRelationFields relationField1 = new GridRelationFields();
gtv.ParentTableRelation.Add(relationField1);
relationField1.MasterKeyField = "LABOR_IDENT";
relationField1.DetailKeyField = "LABOR_IDENT";
}
else
{
rgLEV.MasterTableView.DataKeyNames = new string[] { "WORK_DT_SEQ, LD_STATUS" };
gtv.DataKeyNames = new string[] { "WORK_DT_SEQ, LD_STATUS" };
GridRelationFields relationField1 = new GridRelationFields();
gtv.ParentTableRelation.Add(relationField1);
relationField1.MasterKeyField = "WORK_DT_SEQ";
relationField1.DetailKeyField = "WORK_DT_SEQ";
}
GridRelationFields relationField2 = new GridRelationFields();
gtv.ParentTableRelation.Add(relationField2);
relationField2.MasterKeyField = "LD_STATUS";
relationField2.DetailKeyField = "LD_STATUS";
}

protected void rgLEV_DetailTableDataBind(object sender, GridDetailTableDataBindEventArgs e)
{
GridDataItem gdi = e.DetailTableView.ParentItem as GridDataItem;
string intSeq;
string expression;
if (e.DetailTableView.Name == "gtvDetail1")
{
if (CommonFunctions.GetAMVersion >= 1520.0)
{
intSeq = gdi.GetDataKeyValue("LABOR_IDENT").ToString();
expression = "LABOR_IDENT = '" + intSeq + "'";
}
else
{
intSeq = gdi.GetDataKeyValue("WORK_DT_SEQ").ToString();
expression = "WORK_DT_SEQ = '" + intSeq + "'";
}

e.DetailTableView.DataSource = LoadGridDetail(false, false).Tables["LaborApproval"].Select(expression, "LD_APPROVED_DT asc");
}
}

With this logic, The mastergrid is able to bind to different datakeynames . But in DetailTableDataBind, I am not able to access the datakeynames ( always null).

Do you this this logic will work, or do you suggest to completely build the grid dynamically .

Thank you

answered on 01 Sep 2015, 08:22 AM

Hi Madhavi,

You don't have to define GridRelationFields when binding the grid programmatically:
http://demos.telerik.com/aspnet-ajax/grid/examples/data-binding/programmatic-hierarchy/defaultcs.aspx

I believe both LABOR_IDENT and WORK_DT_SEQ are fields present in the master table database. Why don't you simply use the following approach?

<MasterTableView ... DataKeyNames="LABOR_IDENT,WORK_DT_SEQ">

Also, the programmatic declaration of the data key fields should be modified as follows:

rgLEV.MasterTableView.DataKeyNames = new string[] { "LABOR_IDENT", "LD_STATUS" };

Another solution you can try is get the required values by accessing the Text of the cells, instead of using GetDataKeyValue() method:

protected void RadGrid1_DetailTableDataBind(object sender, GridDetailTableDataBindEventArgs e)

{

GridDataItem parentItem = e.DetailTableView.ParentItem as GridDataItem;

GridColumn col = parentItem.OwnerTableView.GetColumnSafe("ShipName");

if (col != null)

{

TableCell cell = parentItem[col.UniqueName];

string value = cell.Text;

}

...

}

Please make the suggested modifications and let me know about the result.

Regards,
Eyup
Telerik

Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Feedback Portal and vote to affect the priority of the items

answered on 01 Sep 2015, 08:24 PM

Hi Eyup,

Thank you for your suggestions. I have tried with approach one, programmatic declaration of data key fields in page_init, with my RadGrid structure/columns statically declared. But it didn't work, datakeyvalues were not getting assigned to the grid or detailgrid.

protected void Page_Init(object sender, EventArgs e)
{
if (!IsPostBack)
{
if (GetVersion >= 15)
{
rgLEV.MasterTableView.DataKeyNames = new string[] { "LABOR_IDENT", "LD_STATUS" };
rgLEV.MasterTableView.DetailTables[0].DataKeyNames = new string[] { "LABOR_IDENT", "LD_STATUS" };
}
else
{
rgLEV.MasterTableView.DataKeyNames = new string[] { "WORK_DT_SEQ", "LD_STATUS" };
rgLEV.MasterTableView.DetailTables[0].DataKeyNames = new string[] { "WORK_DT_SEQ", "LD_STATUS" };
}
}
}

And I also checked how the grid would display, if I removed the assignment of datakeys from page_init. The grid displayed fine, with datakeyvalues being null. It looks like the Page_Init code, has no effect to the grid.

I thought grid setting EnableViewState=false & EnableColumnViewState=false & AutoGenerateColumns=false and assigning datakeys dynamically in page_init would work. But no luck. Looks like we need to declare the whole grid dynamically.

answered on 01 Sep 2015, 09:17 PM

I have tried another way, created two nondisplay columns for the datakey's in the grid.

<t:GridBoundColumn DataField="LABOR_IDENT" UniqueName="LD" Display="false" HeaderText="" ReadOnly="true" />
<t:GridBoundColumn DataField="WORK_DT_SEQ" UniqueName="WDSeq" Display="false" HeaderText ="" ReadOnly="true" />

And I am accessing them in the detialtable as follows

protected void rgLEV_DetailTableDataBind(object sender, GridDetailTableDataBindEventArgs e)
{
GridDataItem gdi = e.DetailTableView.ParentItem as GridDataItem;
string intSeq;
string expression;
if (e.DetailTableView.Name == "gtvDetail1")
{
if (CommonFunctions.GetAMVersion >= 1520.0)
{
intSeq = gdi["LD"].Text;
expression = "LABOR_IDENT = '" + intSeq + "'";
}
else
{
intSeq = gdi["WDSeq"].Text;
expression = "WORK_DT_SEQ = '" + intSeq + "'";
}
e.DetailTableView.DataSource = xxxx;

}

So far, It works fine, able to get detail grid displayed.

Thank you Eyup.

But is it possible to dynamically assign datakeys to the static grid. If possible, can you share some sample code.

Thank you.

Accepted

answered on 02 Sep 2022, 12:38 PM

Obviously there was no answer within the last 7 years.

Here is a workaround which works fine if you can limit the possible number and names of the primary key columns to 2 or 3.

In my case I have to types of tables, one type with "ID" as PK, the other have a column named "RecordIdentifier" as PK.

I declare both for the gridview:

<MasterTableView Name="MainTable" DataKeyNames="ID, RecordIdentifier" EditMode="InPlace" ...

In NeedDataSource I check if the table has the one or the other PK:

         If currentPKName.Text = "ID" Then
            sql = "select Null as RecordIdentifier, * from " & currentTable.Text
         Else
            sql = "select Null as ID, * from " & currentTable.Text
         End If
and add the missing column with a Null value to the select.

Thus The gridview always has his expected key columns and I can deal with the two different cases in the code.