Excel Like Grid

[Dennis]

Hi,

I want a Grid to behave somewhat like Excel where if the cell has numeric data, it should appear on the right of the cell and if contains a non-numeric data, it should appear on the left of the cell. Please let me know how to achieve this with the RadGrid Control.

Thanks.

[Princy]

Hello David,

You can set alighment of cell depending on column. Sample code is given below.

C#:

protected void RadGrid1_ItemDataBound(object sender, GridItemEventArgs e)
    {
       if (e.Item is GridDataItem)
        {
            GridDataItem item = (GridDataItem)e.Item;
            TableCell cell1 = (TableCell)item["total"];//numeric data
            cell1.Style["text-align"] = "right";
            TableCell cell2 = (TableCell)item["Name"];
            cell2.Style["text-align"] = "left";
        }
   }

Thanks,
Princy.

[Dennis]

Hi Princy,

Thanks for the Reply. Well my Grid has AutoGeneratedColumns and the DataSource for the Grid is not static at all. So i want it in a way that a Grid to automatically detect from the Database that if the column is numeric then the alignment of the data in the cell to be in right and if non-numeric then alignment to be on left. Please let me know how would this be possible.

Thanks.

[Shinu]

Hello David,

If you want to align AutoGeneratedColumns based on its data type, try the following code snippet.

C#:

protected void RadGrid1_ItemDataBound(object sender, GridItemEventArgs e)
   {
       if (e.Item is GridDataItem)
       {
           GridDataItem item = (GridDataItem)e.Item;
           foreach (GridColumn col in RadGrid1.MasterTableView.AutoGeneratedColumns)
           {
               TableCell cell = (TableCell)item[col.UniqueName];
               if (col.DataType.FullName == "System.String")
                   cell.Style["text-align"] = "left";
               else
                   cell.Style["text-align"] = "right";
           }
        }
   }

-Shinu.

[Joel]

Hello, I've implemented the Excel look and feel for RadGrid (i got it from here http://www.telerik.com/support/code-library/excel-look-and-feel-for-radgrid).

The thing is our customer has asked us to add a template column containing a RadComboBox with checkboxes enabled.

My problem is I cannot find the way to to access this radcombobox after a row is inserted, therefore the grid is reseting all the selected checkboxes when the postback happens. 

Is it possible to do this or this "type" of grid is Restricted to GridBoundColumn, GridDropDownColumn, GridNumericColumn, GridMaskedColumn, and GridDateTimeColumn column types.??

When I try to loop thru the column controls I get the error Object reference not set to an instance of an object.

private object GetColumnValue(GridColumn column, GridDataItem item)
    {
        Hashtable table = new Hashtable();
        item.ExtractValues(table);

        switch (column.ColumnType)
        {
            case "GridTemplateColumn":
                //if (column.UniqueName == "CategoryIDs")
                {
                    foreach (Control c in item[column.UniqueName].Controls)
                    {
                        UB.MSSql.WebLog(c.ID);
                    }
                }
                return null;
            default:

                return table[column.UniqueName];
        }

    }

Any help would be appreciated.

Thanks

[Joel]

Nevermind found the way to do it.


Thanks