c# - How do I only encode and decode particular column in sql table and take it into stringBuilder? -

c# - How do I only encode and decode particular column in sql table and take it into stringBuilder? -

i have 1 sql table mytable in table in 1 column having encoded html text want take text in decoded format , fill dataset.

mytable

name address text aaa ind '</p><p class="msonormal" style="margin: 0in 0in 6pt;"><i><span style='color: rgb(7, 44, 149); line-height: 115%; font-family: "segoe ui","sans-serif"; font-size: 10pt;'>please note: computer generated.'

now in c# tried fetch info mytable below

stringbuilder sb = new stringbuilder(); sb.append(string.format("select * mytable")); sqldataadapter sqldataadapter = new sqldataadapter(sb.tostring(), sqlconnection); sqldataadapter.selectcommand.commandtimeout = 3000; sqldataadapter.fill(ds);

now want decode text column , when i'm fetching. how can it?

you can

httputility.htmldecode()

see here : http://msdn.microsoft.com/en-us/library/7c5fyk1k.aspx

c# mysql sql sql-server