Hi,

You won't be able to directly place server controls like asp:HyperLink inside the Grid cell. You can put raw HTML directly inside the cell, or set the Column's DataFormat to some HTML code. For example:

1. If your data source contains the following HTML:



Populate the Grid from the data source would render a link in the cell with text "Test", clicking "Test" would show message box "hi". The rule here is it takes whatever HTML you feed to it and puts it inside the cell;

2. If your data source contains only the data, for example, just "hi", you can set the column's DataFormat to



Populate the Grid from the data source would have the same result as #1. The rule here is if DataFormat is set, the Grid takes whatever data you feed to it, format with DataFormat, and then puts the result inside the cell;

Using this method should allow you to put anything inside the cell.

Thanks!

Hi,

You can cast it to a string in your SQL. For example, if you had



You can change it to



Note you will need to use the "new_field_name" from your Grid. Also make sure you delete the space between the letters for the word "cast".

Thanks