try
{
if (!string.IsNullOrEmpty(fileName) && System.IO.File.Exists(fileName))
{
string connString = "Data Source = 127.0.0.1;Initial Catalog = dbName;User ID = uuu;Password = ppp";
MySqlConnection conn = new MySqlConnection(connString);
conn.Open();
string sql = "Insert into orderPrint(ordersn,image,FileName) values (@ordersn,@image,@FileName)";
MySqlCommand cmd = new MySqlCommand(sql, conn);
string picturePath = fileName;
FileStream fs = new FileStream(picturePath, FileMode.Open, FileAccess.Read);
Byte[] mybyte = new byte[fs.Length];
fs.Read(mybyte, 0, mybyte.Length);
fs.Close();
MySqlParameter prm = new MySqlParameter
("@image", MySqlDbType.VarBinary, mybyte.Length, ParameterDirection.Input, false, 0, 0, null, DataRowVersion.Current, mybyte);
cmd.Parameters.Add(prm);
cmd.Parameters.Add(new MySqlParameter("@ordersn", ordersn));
cmd.Parameters.Add(new MySqlParameter("@FileName", System.IO.Path.GetFileName(fileName)));
cmd.ExecuteNonQuery();
cmd.Dispose();
conn.Close();
}
}
catch (Exception)
{
}