escape character

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • lyne_asp
    New Member
    • Aug 2006
    • 20

    escape character

    Hi Everybody,

    please help me.I have a select statement


    OracleDataAdapt er adOpenFile = new OracleDataAdapt er("SELECT LINK FROM SIXSIGMA_USER.P ROJECT_ATTACHME NT " +" WHERE ITEM_NO = '" + e.CommandArgume nt.ToString() + "' ", Con);
    DataSet dsOpenFile = new DataSet();
    adOpenFile.Fill (dsOpenFile);

    Response.Write( "<script>alert( '" + dsOpenFile.Tabl es[0].Rows[0][0].ToString() + "')</script>");


    When I response.write the output is

    D:WebSite1SIXSI GMABudget_Plann er.xls

    it should be:

    D:\WebSite1\SIX SIGMA\Budget_Pl anner.xls

    and also it is the correct to opne the file

    ClientScript.Re gisterStartupSc ript(typeof(str ing), Guid.NewGuid(). ToString(), "<script>functi on openFile() {window.locatio n= 'file:///@" + dsOpenFile.Tabl es[0].Rows[0][0].ToString() + "' + document.form1. LinkButtonFile. value ;}</script>");


    Thanks
Working...