Problem with gridview to display data from database

Question

Hi..

In my asp project,i have used gridview to display data from database.I need to retrieve the data.One cell conatins data like 'A & B'.i.e data contains '&' symbol.But when i retrieve the data.I get the result as 'A &B'.So i cannot retrive the data from databse.How to solve this...I have used the code string a=gridview1.selectedRaw.cell[1].text.

Santhosh Kumar Jayaraman · Answer

string a=gridview1.selectedRaw.cell[1].text..ToString().Replace("&","&")

Satyapriya Nayak · Answer

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

Santhosh Kumar Jayaraman · Answer

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

Santhosh Kumar Jayaraman · Answer

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.

Resmy Ravi · Answer

thanks..it worked.but can you say why it is so? any problem with the gridview control..The displayed string is customer company name.so if the name contains 'amp' it self .it will be replaced no...

Problem with gridview to display data from database

Thiyagarajan E