how to get away with   and & while reading column value of gridview

Posted by Laghaterohan under C# on 9/22/2013 | Points: 10 | Views : 13542 | Status : [Member] | Replies : 4

Write New Post |

Search Forums | Answered

Resolved Posts |

Un Answered Posts |

Forums Home

Hello,

I have binded a gridview, wherein sometimes I get values for some columns as Blank. While reading the text from these blank columns I get text of these blank columns as  
and hence my validation to check if the column value is null or empty fails.

I need to know how to prevent this? ie. if the column value is blank, then I should get it as empty string only while reading the text from this column and not  

Please help...

Best Regards,
Rohan Laghate

Reply | Reply with Attachment

Alert Moderator

Responses

Posted by: Bandi on: 9/23/2013 [Member] [MVP] Platinum | Points: 25

0	Two approaches to resolve the issue: 1) Raplace &nbps; with Empty string while retrieving value from gridview cell txtComment.Text = row.Cells[3].Text.Replace(" ", ""); 2) In the validation itself check for &nbps; If ( row.Cells[3].Text == "&nbps;") { //Your Code here } Reference: http://stackoverflow.com/questions/3737867/prevent-empty-gridview-data-from-populating-nbsp-into-textbox Mark This Response as Answer -- Chandu http://www.dotnetfunda.com/images/dnfmvp.gif Laghaterohan, if this helps please login to Mark As Answer. \| Alert Moderator

Two approaches to resolve the issue:
1) Raplace &nbps; with Empty string while retrieving value from gridview cell

txtComment.Text = row.Cells[3].Text.Replace("&nbsp;", "");

2) In the validation itself check for &nbps;

If ( row.Cells[3].Text == "&nbps;") 

{

      //Your Code here 

}

Reference:
http://stackoverflow.com/questions/3737867/prevent-empty-gridview-data-from-populating-nbsp-into-textbox

Mark This Response as Answer
--
Chandu
http://www.dotnetfunda.com/images/dnfmvp.gif

Laghaterohan, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Nismeh on: 9/23/2013 [Member] Starter | Points: 25

0	You need to check your text is '&nbps' or not. If it is than you can set is null... as in previous example If ( row.Cells[3].Text == "&nbps;") { // Make Your check/set variable is null } You can even go through string operation by replacing text. IT KNOWLEDGE IS APPLIED KNOWLEDGE So Just Do It Laghaterohan, if this helps please login to Mark As Answer. \| Alert Moderator

Posted by: Rimi1289 on: 9/23/2013 [Member] Starter | Points: 25

0	CODE BEHIND Trim(Replace(.Rows(iRow).Cells(iCol).Text, " ", "")) JAVASCRIPT .replace(/,/g, '') Laghaterohan, if this helps please login to Mark As Answer. \| Alert Moderator

Posted by: Carlitos12 on: 2/23/2017 [Member] Starter | Points: 25

0	use this: Server.HtmlDecode() txtComment.Text = Server.HtmlDecode(row.Cells[14].Text); it handles not only spaces, but also other conversions like for ampersands(&), etc. Laghaterohan, if this helps please login to Mark As Answer. \| Alert Moderator

Latest Posts

how to get away with &nbsp; and &amp; while reading column value of gridview

Responses

how to get away with and & while reading column value of gridview