mathieu_cupryk
asked on
ascii charact coming back from database.
I have the following:
txtProblem.Text = TicketDS.Tables[0].Rows[0] ["ProblemN ote"].ToSt ring();
========================== ========== ========== ========== =
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
========================== ========== ========== ========
txtProblem.Text = TicketDS.Tables[0].Rows[0]
==========================
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
==========================
'
Is this data coming like that from db or are you doing any sort of HtmlEncode or alike with it before displaying?
Try this:
txtProblem.Text = HttpUtility.HtmlDecode(TicketDS.Tables[0].Rows[0]["ProblemNote"].ToString());
You need to include the System.Web namespace to use the above.
ASKER
if (TicketDS != null && TicketDS.Tables.Count != 0 && TicketDS.Tables[0].Rows.Co unt > 0)
{
txtActionTaken.Text = HttpUtility.HtmlDecode(Tic ketDS.Tabl es[0].Rows [0]["Actio nNote"].To String());
TicketNumber.Text = HttpUtility.HtmlDecode(Tic ketDS.Tabl es[0].Rows [0]["Ticke tNumber"]. ToString() );
txtClosedBy.Text = HttpUtility.HtmlDecode(Tic ketDS.Tabl es[0].Rows [0]["Agent Closed"].T oString()) ;
txtCreatedBy.Text = HttpUtility.HtmlDecode(Tic ketDS.Tabl es[0].Rows [0]["Agent Created"]. ToString() );
txtDateAssigned.Text = HttpUtility.HtmlDecode(Tic ketDS.Tabl es[0].Rows [0]["DateA ssigned"]. ToString() );
txtDateClosed.Text = HttpUtility.HtmlDecode(Tic ketDS.Tabl es[0].Rows [0]["DateC losed"].To String());
txtDateCreated.Text = HttpUtility.HtmlDecode(Tic ketDS.Tabl es[0].Rows [0]["DateC reated"].T oString()) ;
txtDateFollowup.Text = HttpUtility.HtmlDecode(Tic ketDS.Tabl es[0].Rows [0]["Follo wupBy"].To String());
txtExternalTicket.Text = HttpUtility.HtmlDecode(Tic ketDS.Tabl es[0].Rows [0]["Exter nalTicket" ].ToString ());
txtFollowupNotes.Text = HttpUtility.HtmlDecode(Tic ketDS.Tabl es[0].Rows [0]["Follo wupNote"]. ToString() );
txtLastUpdate.Text = HttpUtility.HtmlDecode(Tic ketDS.Tabl es[0].Rows [0]["DateL astModifie d"].ToStri ng());
txtProblem.Text = HttpUtility.HtmlDecode(Tic ketDS.Tabl es[0].Rows [0]["Probl emNote"].T oString()) ;
txtShortDescription.Text = HttpUtility.HtmlDecode(Tic ketDS.Tabl es[0].Rows [0]["Short Descriptio n"].ToStri ng());
txtSolution.Text = HttpUtility.HtmlDecode(Tic ketDS.Tabl es[0].Rows [0]["Solut ionNote"]. ToString() );
txtSubmitVia.Text = HttpUtility.HtmlDecode(Tic ketDS.Tabl es[0].Rows [0]["Ticke tApplicati onType"].T oString()) ;
txtTrackIt.Text = HttpUtility.HtmlDecode(Tic ketDS.Tabl es[0].Rows [0]["Track It"].ToStr ing());
txtUserID.Text = HttpUtility.HtmlDecode(Tic ketDS.Tabl es[0].Rows [0]["UserI D"].ToStri ng());
uxLookupFieldTicketStatus1 .DefaultVa lue = TicketDS.Tables[0].Rows[0] ["TicketSt atus"].ToS tring();
uxLookupFieldTicketAgentFo lowup1.Def aultValue = TicketDS.Tables[0].Rows[0] ["AgentFol lowup"].To String();
uxLookupFieldTicketType1.D efaultValu e = TicketDS.Tables[0].Rows[0] ["TicketTy pe"].ToStr ing();
uxLookupFieldTicketService Impact1.De faultValue = TicketDS.Tables[0].Rows[0] ["ServiceI mpact"].To String();
uxLookupFieldTicketLocatio nSIMs1.Def aultValue = TicketDS.Tables[0].Rows[0] ["Location SIMs"].ToS tring();
uxLookupFieldTicketRequest Type1.Defa ultValue = TicketDS.Tables[0].Rows[0] ["RequestT ype"].ToSt ring();
uxLookupFieldTicketPriorit y1.Default Value = TicketDS.Tables[0].Rows[0] ["Priority "].ToStrin g();
uxLookupFieldTicketContact Method1.De faultValue = TicketDS.Tables[0].Rows[0] ["ContactM ethod"].To String();
uxLookupFieldTicketAssigne dTo.Defaul tValue = TicketDS.Tables[0].Rows[0] ["Assigned To"].ToStr ing();
}
is it ok for each textbox that is being assigned,
{
txtActionTaken.Text = HttpUtility.HtmlDecode(Tic
TicketNumber.Text = HttpUtility.HtmlDecode(Tic
txtClosedBy.Text = HttpUtility.HtmlDecode(Tic
txtCreatedBy.Text = HttpUtility.HtmlDecode(Tic
txtDateAssigned.Text = HttpUtility.HtmlDecode(Tic
txtDateClosed.Text = HttpUtility.HtmlDecode(Tic
txtDateCreated.Text = HttpUtility.HtmlDecode(Tic
txtDateFollowup.Text = HttpUtility.HtmlDecode(Tic
txtExternalTicket.Text = HttpUtility.HtmlDecode(Tic
txtFollowupNotes.Text = HttpUtility.HtmlDecode(Tic
txtLastUpdate.Text = HttpUtility.HtmlDecode(Tic
txtProblem.Text = HttpUtility.HtmlDecode(Tic
txtShortDescription.Text = HttpUtility.HtmlDecode(Tic
txtSolution.Text = HttpUtility.HtmlDecode(Tic
txtSubmitVia.Text = HttpUtility.HtmlDecode(Tic
txtTrackIt.Text = HttpUtility.HtmlDecode(Tic
txtUserID.Text = HttpUtility.HtmlDecode(Tic
uxLookupFieldTicketStatus1
uxLookupFieldTicketAgentFo
uxLookupFieldTicketType1.D
uxLookupFieldTicketService
uxLookupFieldTicketLocatio
uxLookupFieldTicketRequest
uxLookupFieldTicketPriorit
uxLookupFieldTicketContact
uxLookupFieldTicketAssigne
}
is it ok for each textbox that is being assigned,
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks.