managing escape character from windows form to mysql

Question

0.00/5 (No votes)

See more:

i have designed a windows forms which has a textbox in it,in that textbox i will enter path and on click of button i will bind that data to database(mysql) and i am done with it.but if the entered path contains '\'(escape character) it will be ignored while binding for e.g, if E:\folder is path it will be entered as E:folder into database,and user wont enter \\ when entering a path,how to solve this prob,

<pre lang="cs">private string filepath(string FilePath)
        {
            char[] splitpath=FilePath.ToCharArray();;
            for(int i=0;i<splitpath.Length;i++)
            {
                char s=splitpath[i];
                if (c == '\')//error at this line
                   {
                 string path= s.Replace('\' , '\\');//error at this line also
                   }
            }
        return path;
        }

even this code is giving error

errors are
too many character in character literal(CS1012)
new line in constant(CS1010)
unexpected character(CS1056)

thanks in advance,

Posted 5-May-11 18:20pm

girish sp

Updated 5-May-11 19:31pm

v5

Add a Solution

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Sandeep Mewara · Answer 1 · 2011-05-05T18:30:00

Solution 1

user wont enter \\ when entering a path
Yes true. But you can handle it internally in the code! What say? :)

Try:

C#

private string FormattedFilepath(string FilePath)
{
   string path= FilePath.Replace('\' , '\\');
   return path;
}

Posted 5-May-11 18:30pm

Sandeep Mewara

Updated 5-May-11 19:36pm

v3

Comments

girish sp 6-May-11 0:33am

i know that,that's where i am facing prob,

Sandeep Mewara 6-May-11 1:03am

Which part of your question speaks of that? If you are facing problem with that then you should share what you were trying and found not working for you.

Tried '@' before the string?

girish sp 6-May-11 1:20am

i have shared the code,pls check out and let me know

Sandeep Mewara 6-May-11 1:25am

You forgot to add what error!

girish sp 6-May-11 1:32am

sorry,,i have added what errors i got!

Sandeep Mewara 6-May-11 1:36am

Updated answer.

girish sp 6-May-11 2:56am

if @ is used before the string then it will add \ to database as u said, will the following code work??or is there any other way to append @ and then send to mysql??
FilePath=FilePath.Insert(0,"@");

CodeHawkz · Answer 2 · 2011-05-05T21:08:00

Solution 2

Hi there,

Please, help me understand your question. You are trying to write a file path to the database right?

I just tested, the textbox returns an escaped string instead of the value you just entered. For instance if you entered "C:\Data.txt", the value returned is "C:\\Data.txt".

Next thing is, if you used "DbParameter" class to supply the file path parameter instead of constructing your query with string concatenation, it will automatically add required escape characters :) I.e. it would transform the value "C:\\Data.txt" to "C:\\\\Data.txt" and send it to the database.

Let me know if I am missing anything. Sadly, I don't have any database server installed in this PC so I could do a simple sample for you and post :\

Hope this helps :) Regards

Posted 5-May-11 21:08pm

CodeHawkz

Comments

girish sp 6-May-11 3:12am

i am using the mysql database ,but unfortunately if you enter C:\data.txt it will be considered as C:data.txt
as merwara said i tried to insert@before the string it enters as @C:data.txt
i know @ works but i dont know the way to use with the string

CodeHawkz 6-May-11 3:29am

Wow. I have done many applications which involved storing file paths in the database, but a similar problem never occurred to me. May be this is a MySQL issue, I know not.

I'd surely go home, try it out myself, and post here.

On a final note, can you post the code in which you get the file path and pass it on to MySQL (database code part?). If it's a glitch in your code, I'd be able to help you sooner.

Regards

girish sp 6-May-11 4:13am

public int Insert(int printerid,int id,string FilePath,string FileName)
{
MySqlCommand cmd=null;
try
{
con.Open();
string str=string.Format("INSERT INTO tbl_Driver(tbl_PrinterName_id_fk,tbl_id_fk,tbl_filePath,tbl_fileName)VALUES('{0}','{1}','{2}','{3}')",printerid,id,FilePath,FileName);
cmd=new MySqlCommand(str,con);
return cmd.ExecuteNonQuery();
}
catch (Exception ex)
{
throw ex;
}
finally
{
if(con!=null)
{
con.Close();
con.Dispose();
}
if(cmd!=null)
{
cmd.Dispose();
}
}
}