Problem with gridview to display data from database

Also this is not problem with gridview control. Whenever you design a web application with html,php, you will face the similar issue.

Hi,

Ampersand &  is a special character with different meaning in html. characters such as <,>,& will give those issues.

If you really want to get rid of it, you should use HtmlEncode when getting it from database and use htmldecode for the reverse i.e. saving it back to database.

The below link will be useful to understand more.
http://msdn.microsoft.com/en-us/library/w3te6wfz.aspx

You can also try
string a =Server.HtmlEncode(gridview1.selectedRaw.cell[1].text.ToString());

And for your question about company name with "amp". We replace only if the string contains "&" and not just for "amp", so its a very rare scenario where companyname have both & and ; character togehter.

Hi Resmy,


Try this...


Remove it from database table.


UPDATE employee
SET EmpName = REPLACE(EmpName , '&', '&')
WHERE EmpName LIKE '%&%'


OR

lbl_name.Text = GridView1.SelectedRow.Cells[1].Text.ToString().Replace("&", "&");



Thanks