我正在尝试将用户打开的图像目录保存到数据库中。但是符号“ \”不在路径中。结果就像C:UsersAshleyDesktopScreenshot_1.png一样,您可以看到它没有no \
,这使其成为无效路径。
private void button1_Click(object sender, EventArgs e)
{
OpenFileDialog open = new OpenFileDialog();
if (open.ShowDialog() == DialogResult.OK)
{
pictureBox1.Image = Image.FromFile(open.FileName);
pictureBox2.Image = Image.FromFile(open.FileName);
MySQL.ExecuteNonQuery(@"UPDATE users SET profile_image_dir = '" + open.FileName + "' WHERE username = '" + User.Details.Username + "'");
MessageBox.Show(""+ open.FileName + "\r\n");
}
在MySQL.ExecuteNonQuery上,我将其保存到数据库中,结果如前所述
参数化查询应该有效
string cmdText = @"UPDATE users SET profile_image_dir = @file
WHERE username = @uname";
using(MySqlConnection cn = new MySqlConnection(.....))
using(MySqlCommand cmd = new MySqlCommand(cmdText, cn))
{
cn.Open();
cmd.Parameters.AddWithValue("@file", open.FileName);
cmd.Parameters.AddWithValue("@uname", User.Details.Username);
cmd.ExecuteNonQuery();
}
本文收集自互联网,转载请注明来源。
如有侵权,请联系[email protected] 删除。
我来说两句