how to save full image path in mysql table? (with wpf)

See more:

WPF

MySQL

Hi friends,

I am try to save image path in mysql using C#,. I fetch the path in textbox3 and i add to mysql. the location has inserted. but correctly ,.

E:\mcsKIOSK\Image Files\Mcubic.png is correct. but the table it shows only E:mcsKIOSKImage FilesMcubic.png ,. If i try to access image whith this it gives error na.

Is any way to insert full path in mysql table?. i set varchar 100 for this.

Microsoft.Win32.OpenFileDialog dlg = new Microsoft.Win32.OpenFileDialog();
                dlg.Filter = "All Image Files | *.*";
                if (dlg.ShowDialog() == true)
                {
                    image1.Source = new BitmapImage(new Uri(dlg.FileName, UriKind.Absolute));
                    string FileName = System.IO.Path.GetFileName(dlg.FileName);
                    string a = "E:\\jaga\\Files\\" + FileName;
                    string folderpath = "E:\\jaga\\Files\\";
                    System.IO.Directory.CreateDirectory(folderpath);
                    textBox3.Text = a;
                    if (!File.Exists(dlg.FileName))
                    {
                        MessageBox.Show("File Not Exit");
                    }
                    if (File.Exists(a))
                    {
                        MessageBox.Show("File Already Exit");
                    }
                    File.Copy(dlg.FileName, "E:\\jaga\\Files\\" + FileName);
                }

at last i try

string a = @"E:\jaga\Files\" + FileName;

way also,.

help me,.