Thanks. Worked like a charm.

 Setting SelectTypeCol to None (as the sample code above shows) should prevent the column from being selected.

Hi Mike,

 This is pradeep. I am having one issue with Ultrawingrid regarding sorting. When the data is loaded for the first time, when i click on column header, it  is sorting correctly. But the problem is, when the data is unloaded, this sorting(column sorting) is still enable, which means when i load the data once again, it is displaying data in sorted order(Taking previous column header click as reference). "When the data is unloaded, i need sorting to be disabled,  which means after the data is loaded again, data should be sorted when we click on column header again." I have used the above mention method for sorting the data. So please give me a solution.

Regards,

Pradeep 

Pradeep,

If you want to reset the sorted columns when unloading then reloading your data, you will simply need to clear the sorted columns, i.e.:

 this.ultraGrid1.DisplayLayout.Bands[0].SortedColumns.Clear();

-Matt

Hi,

I have one more doubt regarding sorting. How to display the data in sorted order(Based on any column number given by us) while displaying data on the UltraWingrid for the first time(With out clicking on ultrawingrid). 

-Pradeep 

 Pradeep,

You can add a column to the SortedColumns collection yourself, i.e.:

 this.ultraGrid1.DisplayLayout.Bands[0].SortedColumns.Add("My Column Key", false);

-Matt

 Hi,

 I have one more problem.  I am converting a VB application in to Dot Net.  In VB earlier FPSpread is used to display the data and now we are using UltraGrid.  The problem is while sorting coloumns in FPSpread, we can mention the range of coloumns to be sorted as given below:

 fpObjects.SortKey(1) = COL_SEVERITYHIDDEN 

         fpObjects.col = 1
        fpObjects.Col2 = fpObjects.MaxCols (in present case 7)
        fpObjects.Row = 1
        fpObjects.Row2 = fpObjects.MaxRows (in present case 6)
        fpObjects.Action = ActionSort

The description for fpObjects.col and fpObjects.Col2 given in fpspread are  "Sets or returns a specific column or specifies the first column of a block of cells on which an operation is to occur." and "Sets or returns the last column of a block of cells on which an operation is to occur."

Do we have any such properties in Ultra Grid, where we can sort a particular range of coloumns i.e., from coloumn 1 to 7 and from Row 1 to 6.

Thanks, 

Pradeep