Using C#.

I am currently displaying data in a webform using the datagrid control.

How can I wrap HTML around 1 of the fields in my table to create a hyper link?

I tried this, but it didn't work:
oleDbCommand1.CommandText =
"SELECT " +
"" +
"mytable.cu_name" + "" + " AS Company, " +
"mytable.cu_profess AS Profession, " +
"mytable.cu_fulname AS Full_Name " +
"FROM mytable WHERE mytable.name LIKE '" + lc_somevar + "%' "

When I did a build and browse, I got a "Command contains unrecognized phrase/keyword" in the browser.

Using Web Connect, I can:
SELECT ;
"" + ;
ALLTRIM(mytable.field) + ;
"" AS myheader, ;
FROM mytable ;
INTO CURSOR mycursor NOFILTER

How can I do this in C#?

Thanks,

Jerryt