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,i know using @ would solve the problem,but still i am not able to do that,i am using property to read n write the file path,can i append @ in the property itself??or is there any other way to do that??

C#

public stringFilePath
        {
            get {return this.FilePathTextBox.Text.Trim();}
            set {this.FilePathTextBox.Text = value;}
        }

Posted 12-May-11 18:10pm

girish sp

Add a Solution

4 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)

Kim Togo · Accepted Answer · 2011-05-12T23:18:00

Solution 4

Check out static string MySqlHelper.EscapeString(string value) it takes care of must escaping on a string. But better is to use MySqlParameter.

Posted 12-May-11 23:18pm

Kim Togo

Comments

girish sp 13-May-11 5:21am

where should i use this??i am passing path to a method,before passing as an argument it should consider \ in the path?

Wayne Gaylard · Accepted Answer · 2011-05-12T21:53:00

Solution 3

You can just use Replace to convert "\" to "\\" like this

C#

public string FilePath
        {
            get{return textBox1.Text.Trim();}
            set { this.textBox1.Text = value.Replace(@"\", @"\\"); }
        }

Hope this Helps

Here is the code for the whole form I used for testing :

C#

public string FilePath
        {
            get{return textBox1.Text.Trim();}
            set { this.textBox1.Text = value.Replace(@"\", @"\\"); }
        }
        public Form1()
        {
            InitializeComponent();
        }
        public void Save()
        {
            using (MySqlConnection con = new MySqlConnection("server=localhost;User Id=xxxx;password=xxxx;database=xxxx"))
            {
                MySqlCommand cmdSave = new MySqlCommand("UPDATE"
                                                          + " myTable"
                                                  + " SET"
                                                         + " FilePath = @FilePath"
                                                   + " WHERE"
                                                         + " myClassID = @myClassID", con);
                cmdSave.Parameters.AddWithValue("@myClassID", 1);
                cmdSave.Parameters.AddWithValue("@FilePath", FilePath);
                con.Open();
                int rowsAffected = cmdSave.ExecuteNonQuery();
            }
        }
        private void button1_Click(object sender, EventArgs e)
        {
            Save();
        }

and it all works as expected.

Good Luck!!

Posted 12-May-11 21:53pm

Wayne Gaylard

Updated 12-May-11 23:26pm

v2

Comments

girish sp 13-May-11 4:27am

if i enter E:\dir\another,my sql would take it as E:\dirnother,don know why??

Wayne Gaylard 13-May-11 4:34am

I tested it with c:\folder1\folder2\folder3\folder4\test.txt and it works fine on MySQL 5.1 using .Net connector 6.3.3.0. I think you may have entered the info incorrectly maybe?

girish sp 13-May-11 5:15am

when i see the value at run time before passing it to a method ,it would still be E:\folder1\folder2 ,i don think its replacing the char??

girish sp 13-May-11 5:16am

if i pass E:\\folder1\\folder2,in textbox,in mysql it would display E:\folder1\folder2

girish sp 13-May-11 5:15am

i m using sharpdevelop and mysql workbench

Wayne Gaylard 13-May-11 5:17am

When I put a breakpoint in the setter for FilePath then I get "C:\\Folder1\\Folder2\\Folder3\\Folder4\\test.txt" as expected.

girish sp 13-May-11 5:19am

thats wat i was expecting,even i put a breakpoint and if i check it shows E:\folder1\folder2..

this really sucks!!

girish sp 13-May-11 6:59am

<pre>
public int Insert(int printerid,int roadid,string FilePath,string FileName)
{
MySqlCommand cmd=null;
try
{
con.Open();
string str=string.Format("INSERT"
+"INTO"
+ "tbl_Driver"
+ "VALUES"
+ " tbl_Driver_PrinterName_id_fk=@printerid"
+ " tbl_Driver_roads_id_fk=@roadid"
+"tbl_Driver_filePath=@FilePath"
+ " tbl_Driver_fileName=@FileName");
//as it reads this line null ref exception i get cmd.Parameters.AddWithValue("@printerid",printerid);
cmd.Parameters.AddWithValue("@roadid",roadid);
cmd.Parameters.AddWithValue("@FilePath",FilePath);
cmd.Parameters.AddWithValue("@FileName",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();
}
}
}</pre>

this is giving null reference exception as soon as it reads the command(after the line which i have marked with //)

girish sp 13-May-11 7:51am

thanks very much it worked,but if i place your code in property it did not work out i used the same thing before passing it to the query it worked thanks a lot..

Wayne Gaylard 13-May-11 7:03am

I think you need to check whether the variable PrinterID has been initialised, and so is still null

girish sp 13-May-11 8:08am

thanks for your precious time:) solved..

Wayne Gaylard 13-May-11 9:05am

Pleasure.

mahendren · Accepted Answer · 2011-05-12T20:49:00

Solution 2

Unfortunately, @ is for constant strings.
You need to escape the string yourself...

Posted 12-May-11 20:49pm

mahendren

Comments

girish sp 13-May-11 3:36am

ok,i got..as my string varies for each entry i need to escape it every time..that is where i am struck..

any help would be appreciated.

girish sp 13-May-11 3:39am

my 5

Programm3r · Accepted Answer · 2011-05-12T20:43:00

Solution 1

Hi,

According to the following web site: MySql Strings you can make use of: '\\' -> A backslash ('\') character.'\\'

I think that would solve your problem.

Kind regards,

Posted 12-May-11 20:43pm

Programm3r

Updated 12-May-11 20:44pm

v2

Comments

girish sp 13-May-11 3:38am

thanks very much for the link..
i will revert back if i find any prob,
thanks again,

girish sp 13-May-11 3:39am

my 5

Programm3r 13-May-11 3:53am

great stuff... :)