'@' symbol will not correctly transmit text in URL strings using gridview.

Question

Hi Erland I had the issue with special character '@' symbol. while i try to use in save the column. if my email id like - almubarak.hr@gmail.com means my database table will shows as =almubarak.hrigmail.com. Can you please help me to figure out the issue. when i receive SMS message from any mobile. this things also happening. i already use the below code to URL encoding ensures that all browsers will correctly transmit text in URL strings. Here is my code : ----------------------------------- Server.UrlDecode(Convert.ToString(dr[message_received])) ------------------------------------------- Please help me to resolve the issue soon as possible. Any help will be greatly appreciated. Thanks in advance.

AL MUBARAK · Answer

Hi Suthish Saving the data's using parameter queries. and i just read the stored data with data reader in the table columns. Here like I'm using the code : Report +=   + Convert.ToString(dr[mobile_no]) + Server.UrlDecode(Convert.ToString(dr[message_received])) +   + Convert.ToDateTime(dr[inbox_date]).ToString(dd/MM/yyyy HH:mm:ss:fff) +  ; I'm using the code to use the store the data using SP - like below @mobile_no VARCHAR(50) = NULL @message_received NVARCHAR(MAX) = NULL I hope you understands now. the thing is server not Decode the actual data with special characters while storing the data. Can you please advise me that is there any soemthing wrongly declare in SP or server side coding part. Waiting for your kind reply.

Suthish Nair · Answer

Your question is not clear for me.. How you getting email id in url. How you saving the records to database using parameterized queries?