Solved

ascii charact coming back from database.

Posted on 2009-05-11
6
153 Views
Last Modified: 2012-05-06
I have the following:
     txtProblem.Text = TicketDS.Tables[0].Rows[0]["ProblemNote"].ToString();
=========================================================
Customer email:
I don't think we have received the summary/detail usage stats & bill for lat month (Feb).  Was this an oversight ?
Did this go out? Can you please re- send to them. Is it possible to make sure that they get the usage report every month. Thanks
======================================================


'

Open in new window

0
Comment
Question by:mathieu_cupryk
  • 3
  • 2
6 Comments
 
LVL 9

Expert Comment

by:tillgeffken
ID: 24356275
Is this data coming like that from db or are you doing any sort of HtmlEncode or alike with it before displaying?
0
 
LVL 27

Expert Comment

by:nmarun
ID: 24356278
Try this:

 txtProblem.Text = HttpUtility.HtmlDecode(TicketDS.Tables[0].Rows[0]["ProblemNote"].ToString());

Open in new window

0
 
LVL 27

Expert Comment

by:nmarun
ID: 24356285
You need to include the System.Web namespace to use the above.
0
Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

 

Author Comment

by:mathieu_cupryk
ID: 24356822
if (TicketDS != null && TicketDS.Tables.Count != 0 && TicketDS.Tables[0].Rows.Count > 0)
            {
                txtActionTaken.Text = HttpUtility.HtmlDecode(TicketDS.Tables[0].Rows[0]["ActionNote"].ToString());
                TicketNumber.Text = HttpUtility.HtmlDecode(TicketDS.Tables[0].Rows[0]["TicketNumber"].ToString());
                txtClosedBy.Text = HttpUtility.HtmlDecode(TicketDS.Tables[0].Rows[0]["AgentClosed"].ToString());
                txtCreatedBy.Text = HttpUtility.HtmlDecode(TicketDS.Tables[0].Rows[0]["AgentCreated"].ToString());
                txtDateAssigned.Text = HttpUtility.HtmlDecode(TicketDS.Tables[0].Rows[0]["DateAssigned"].ToString());
                txtDateClosed.Text = HttpUtility.HtmlDecode(TicketDS.Tables[0].Rows[0]["DateClosed"].ToString());
                txtDateCreated.Text = HttpUtility.HtmlDecode(TicketDS.Tables[0].Rows[0]["DateCreated"].ToString());
                txtDateFollowup.Text = HttpUtility.HtmlDecode(TicketDS.Tables[0].Rows[0]["FollowupBy"].ToString());
                txtExternalTicket.Text = HttpUtility.HtmlDecode(TicketDS.Tables[0].Rows[0]["ExternalTicket"].ToString());
                txtFollowupNotes.Text = HttpUtility.HtmlDecode(TicketDS.Tables[0].Rows[0]["FollowupNote"].ToString());
                txtLastUpdate.Text = HttpUtility.HtmlDecode(TicketDS.Tables[0].Rows[0]["DateLastModified"].ToString());
                txtProblem.Text = HttpUtility.HtmlDecode(TicketDS.Tables[0].Rows[0]["ProblemNote"].ToString());
                txtShortDescription.Text = HttpUtility.HtmlDecode(TicketDS.Tables[0].Rows[0]["ShortDescription"].ToString());
                txtSolution.Text = HttpUtility.HtmlDecode(TicketDS.Tables[0].Rows[0]["SolutionNote"].ToString());
                txtSubmitVia.Text = HttpUtility.HtmlDecode(TicketDS.Tables[0].Rows[0]["TicketApplicationType"].ToString());
                txtTrackIt.Text = HttpUtility.HtmlDecode(TicketDS.Tables[0].Rows[0]["TrackIt"].ToString());
                txtUserID.Text = HttpUtility.HtmlDecode(TicketDS.Tables[0].Rows[0]["UserID"].ToString());
                uxLookupFieldTicketStatus1.DefaultValue = TicketDS.Tables[0].Rows[0]["TicketStatus"].ToString();
                uxLookupFieldTicketAgentFolowup1.DefaultValue = TicketDS.Tables[0].Rows[0]["AgentFollowup"].ToString();
                uxLookupFieldTicketType1.DefaultValue = TicketDS.Tables[0].Rows[0]["TicketType"].ToString();
                uxLookupFieldTicketServiceImpact1.DefaultValue = TicketDS.Tables[0].Rows[0]["ServiceImpact"].ToString();
                uxLookupFieldTicketLocationSIMs1.DefaultValue = TicketDS.Tables[0].Rows[0]["LocationSIMs"].ToString();
                uxLookupFieldTicketRequestType1.DefaultValue = TicketDS.Tables[0].Rows[0]["RequestType"].ToString();
                uxLookupFieldTicketPriority1.DefaultValue = TicketDS.Tables[0].Rows[0]["Priority"].ToString();
                uxLookupFieldTicketContactMethod1.DefaultValue = TicketDS.Tables[0].Rows[0]["ContactMethod"].ToString();
                uxLookupFieldTicketAssignedTo.DefaultValue = TicketDS.Tables[0].Rows[0]["AssignedTo"].ToString();
            }
           

is it ok for each textbox that is being assigned,
0
 
LVL 27

Accepted Solution

by:
nmarun earned 500 total points
ID: 24359253
Looks good.. are you still having that issue?
0
 

Author Closing Comment

by:mathieu_cupryk
ID: 31580215
Thanks.
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

AJAX ModalPopupExtender has a required property "TargetControlID" which may seem to be very confusing to new users. It means the server control that will be extended by the ModalPopup, for instance, if when you click a button, a ModalPopup displays,…
One of the pain points with developing AJAX, JavaScript, JQuery, and other client-side behaviors is that JavaScript doesn’t allow for cross domain request for pulling content. For example, JavaScript code on www.johnchapman.name could not pull conte…
I designed this idea while studying technology in the classroom.  This is a semester long project.  Students are asked to take photographs on a specific topic which they find meaningful, it can be a place or situation such as travel or homelessness.…
This is a video that shows how the OnPage alerts system integrates into ConnectWise, how a trigger is set, how a page is sent via the trigger, and how the SENT, DELIVERED, READ & REPLIED receipts get entered into the internal tab of the ConnectWise …

914 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now