Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. DilipKS

    Reading an XML file into a String and updating Database

    I agree when you display it , it doesnt show "\" but when I try to update into DB using below its giving error Original Msg contains string which has "\" wherever double quotes are there . - string strCmdText = "UPDATE system_exceptions SET OriginalMessage = '" + strOriginalMsg + "' WHERE...
  2. DilipKS

    How to Reomve "\" from a String

    I agree when you display it , it doesnt show "\" but when I try to update into DB using below its giving error Original Msg contains string which has "\" wherever double quotes are there . - string strCmdText = "UPDATE system_exceptions SET OriginalMessage = '" + strOriginalMsg + "' WHERE...
  3. DilipKS

    updating a Text field with a String having " inside

    Got it worked .. UPDATE dbo.SystemExceptions SET OriginalMessage = '<Execution><Account>BZ</Account><SecurityID IDSource="RIC">OML.L</SecurityID></Execution>' WHERE ExcpMsgID=83
  4. DilipKS

    updating a Text field with a String having &quot; inside

    UPDATE dbo.SystemExceptions SET OriginalMessage = "<Execution><Account>BZ</Account><SecurityID IDSource="RIC">OML.L</SecurityID></Execution>" WHERE ExcpMsgID=83 how should I make it work ?
  5. DilipKS

    How to remove &quot;\&quot; from a String

    am still struggling....se the exact thing which i want.... http://www.tek-tips.com/viewthread.cfm?SQID=821855&SPID=732&page=1
  6. DilipKS

    Reading an XML file into a String and updating Database

    Hi I got really one frustrating problem and am struggling with it. I got an XML , I just want to read it in a String and need to insert in Database. But the problem is I tried all ways but whenever I read XML into a String , I get \ inserted before every " . e.g. whereever attrib values r...
  7. DilipKS

    Text Parameter in Sybase Stored Procedure

    whats ASA 6.0 ? I tried ur example but it was not working . ??
  8. DilipKS

    How to remove &quot;\&quot; from a String

    1) I have a XML msg in a field called OrigMsg in a table in Sybase DB. The xml MSg is a continuous string with XML tags. 2) Reading this field from DB and writing it into an XML i.e. StreamWriter sw = new StreamWriter("C:\\Temp\\Test.xml", false ); sw.Write(strOriginalMsg);sw.Close(); where the...
  9. DilipKS

    How to remove &quot;\&quot; from a String

    >>>> Therefore is you wanted to replace the \ there is no need as it is an escape character anyway. I need to replace it because am not printing it or manipulating it..I need to insert this string to Database, its actually a big XML, just for an example i used that string. If I insert this to...
  10. DilipKS

    Text Parameter in Sybase Stored Procedure

    Hi Guys.. ya its limitation that we cant use text or image datatype as parameter in Sybase Stored procedure. So I have dropped the idea of using stored procedure, and using directly "Update" Query SQL . Thnks for ur replys. Cheers Dil
  11. DilipKS

    How to remove &quot;\&quot; from a String

    Hi Rob Thnks for reply I have tried this already ..but its not working . I debugged it and can see the output ..string it still same. string r10 = t10.Replace("\\", ""); Have u run this code ?
  12. DilipKS

    How to remove &quot;\&quot; from a String

    Hi string t10 = "xftag Source=\"L\">500671"; I want to remove "\" from above string and resultant string shld be "xftag Source="L">500671" I have tried many ways but I am not getting the desired output . One of the ways I tried , pls see below string t10 = "xftag Source=\"L\">500671"...
  13. DilipKS

    How to Reomve &quot;\&quot; from a String

    Hi string t10 = "xftag Source=\"L\">500671"; I want to remove "\" from above string and resultant string shld be "xftag Source="L">500671" I have tried many ways but I am not getting the desired output . One of the ways I tried , pls see below string t10 = "xftag Source=\"L\">500671"...
  14. DilipKS

    Text Parameter in Sybase Stored Procedure

    Hi I am facing this problem. On compiling this stored procdure it says "TEXT or IMAGE datatypes are invalid for paramters or local variable" I have OriginalMessage field which containts big XML and its not possible for me to change its datatype from text to some varchar ...any Hope I can...
  15. DilipKS

    Client Machine Name and User Name

    hi am trying to get client machine name and the user name on that machine. Any idea ? I am trying to use - System.Net.Dns.GetHostName() or System.Environment.MachineName but i guess they both gives server name ...not client name For User I am using - System.Environment.UserName but it...
  16. DilipKS

    DataSet - Adding Tables / Appending Records

    Hi I got 4 tables in a DataSet , All 4 tables have same columns ( 2 columns - Field and Value ) . I want to appeand the records of rest 3 tables into 1st table. Any one has idea ?
  17. DilipKS

    Edit/Update in DataGrid - Getting Old Values ????

    Hi Kalisto, I got it worked. It worked after I set EnableViewState to False. DataBind of Grid is fine . Thnks for the reply anyway. Cheers
  18. DilipKS

    Using Microsoft Web Control in ASP .NET - UREGENT

    Hi Jennifer, Thnks for you reply. And again I got my problem fixed as soon as I got ur reply. :):) Actually I was not using the inbuilt functionality of Grid as you suggested in ur reply. I have an update button and am doing multi line editing. I have formed a 2 column Grid one column...
  19. DilipKS

    Using Microsoft Web Control in ASP .NET - UREGENT

    Hi Jennifer... see below problem and if u can help me in that... I am using DataGrid with two columns, one column is read only having label inside and second column having text box inside. ( am using Template column ). Both columns are bind to data columns ( see the code below ). But the...
  20. DilipKS

    Edit/Update in DataGrid - Getting Old Values ????

    Hi I am using DataGrid with two columns, one column is read only having label inside and second column having text box inside. ( am using Template column ). Both columns are bind to data columns ( see the code below ). But the problem am facing is when am updating values in second column i.e...

Part and Inventory Search

Back
Top