Hierarchical Grid

[Rajiv]

Hi,
I have a single level hierarchical grid with 3 detail tables. The Master grid is having the paging and sorting enabled. My requirement is when the user adds a new record in the master table, I want that record to be selected and it's node to be opened(expanded). This should work even if the sort is enable for any of the column.

To select and Open the newly entered node, I tried using RadGrid1.SelectedIndexes.Add( j, 0) method in the prerender event of the rad grid control. but it doesn't seem to work.

Please help.

Thanks,
Rajiv

[Shinu]

Hi Rajiv,

Go through the following code library submission which demostrates how to identify and select the last inserted row using its key value. You can use a similar approach to select and expand the newly inserted row.
Select Last Inserted Row

Thanks
Shinu.

[Rajiv]

Thank you for the reply, Shinu.

I have already refered to the sample code below and I am able to select the last inserted row. But my problem is that I am not able to programmatically expand that selected node. I tired using the SelectedIndexes method in the prerender even of the Radgrid but it is not working.

Please help.

Thanks,
Rajiv 

[Princy]

Hello  Rajiv,

You can use the same approach to expand the item as well.

CS:

protected void RadGrid1_PreRender(object sender, EventArgs e)

{

if(!RadGrid1.MasterTableView.IsItemInserted)

{

// Get the CategoryID of the last inseted record

OleDbConnection MyOleDbConnection = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + Server.MapPath("~//App_Data//Nwind.mdb"));

dtTable = new DataTable();

MyOleDbConnection.Open();

try

{

MyOleDbCommand.CommandText = "SELECT MAX(CategoryID) FROM  Categories";

MyOleDbCommand.Connection = MyOleDbConnection;

intLastCategoryID =Convert.ToInt16(MyOleDbCommand.ExecuteScalar().ToString());

}

finally

{

MyOleDbConnection.Close();

}

// Compare the CategoryID of the each item with the newly inserted record CategoryID

// and select the last inserted row

foreach (GridDataItem item in RadGrid1.Items)

{

int intCategoryID = Convert.ToInt16(item["CategoryID"].Text);

//checking the for the newly inserted ID

if (intCategoryID == intLastCategoryID)

{

item.Selected = true;

//Expand the item

item.Expanded = true;

}

}

}

}

Regards
Princy

[Rajiv]

Thank you, it works.

-Rajiv