Hi Udayan,

You did well to save the table structure of WebGrid. You can save the table structure as simple as that. But, if you want to show the WebGrid in to the saved structure, you have to load the structure. Then, if you want to show the data as well, you have to rebind the data. Please use this code to show your gridView into the saved state.

  gridView.LoadTablesStructureFromXml(Server.MapPath("layout.xml"));
  gridView.RebindDataSource();

Hope this helps.
Riendy

Riendy,

Thanks for the quick reply. But I am not able to save the correct table structure to the XML. It is saving the default structure that was bound to the grid initially. Following is the scenario-

a) I bind the dataset to the grid using OnInitialize and PrepareDatabinding events.

b) I change the column positions. (No flypostback happens)

c) I click the save button to save the new structure.

The saved xml doesnt contain the information about the change in the column positions, but instead saves the original structure. 

Please suggest how to save the new table structure with new column position information.

Thanks

Udy

Hi Udayan,

First of all, I am sorry for my mistake. You should not use SaveTablesStructureToXml and LoadTablesStructureToXml, you have to use SaveTablesStructure and LoadTablesStructure.

Let me assist you for a simple sample to save a table structure. After you bind the data into WebGrid, please add 2 buttons. Then add the codes bellow to each button.

   protected void Button1_Click(object sender, EventArgs e)
    {
           WebGrid1.SaveTablesStructure(Server.MapPath("SampleLayout.xml"));
           // you can also use another file (i.e .isl file)
           // WebGrid1.SaveTablesStructure(Server.MapPath("SampleLayout.isl"));
    }
    protected void Button2_Click(object sender, EventArgs e)
    {
        WebGrid1.LoadTablesStructure(Server.MapPath("SampleLayout.xml"));
        //WebGrid1.LoadTablesStructure(Server.MapPath("SampleLayout.isl"));
        WebGrid1.RebindDataSource();
    }

Regards.
Riendy

Thanks for the reply Riendy. 

After I change the position of the columns inside the webgrid from the UI and then call Button1_Click event, I am not able to save the new structure. It is taking the original structure. 

For example - say my grid is bound to a datatable with two columns A and B, with A at position 0 and B at position 1. when I swap the column-positions on the UI and then call the Button1_click event, the xml/isl file still shows the position of the column A as 0 and B as 1. It should show A as 1 and B as 0.

Please assist.

Hi Udayan,

Basically to save a table structure in some state, you have to save the structure when it's on the right structure which you want. Then you should use LoadTablesStructure method to load the structure which you saved before (or based on table structure file).

For a simple sample, you can create a WebGrid then Bind the data and add 2 button to save and load the structure. Next, on button1 and button2 click event, please follow the snippet code above.
Attached is a simple runable sample that show you how to save and load the table structure in WebGrid.

Please let me know if you still unable to save and load the table structure in WebGrid.

Thanks.
Riendy