文件上传保存到mysql报错,请帮忙。。。
代码如下:
if (fileSignaturePicture.Value.Trim() != "" && fileSignaturePicture.PostedFile != null)
{
System.IO.Stream ms = fileSignaturePicture.PostedFile.InputStream;
int length = fileSignaturePicture.PostedFile.ContentLength;
byte[] img = new byte[length];
ms.Read(img, 0, length);
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into usersignaturepicture(");
strSql.Append("UserID,SignaturePicture)");
strSql.Append(" values (");
strSql.Append("?UserID,?SignaturePicture)");
strSql.Append(";SELECT LAST_INSERT_ID()");
MySqlParameter[] parameters = {
new MySqlParameter("?UserID", MySqlDbType.Int32,11),
new MySqlParameter("?SignaturePicture", MySqlDbType.MediumBlob)};
parameters[0].Value = 1;
parameters[1].Value = img;
MySqlCommand comm = new MySqlCommand(strSql.ToString(), conn);
comm.Parameters.Add(parameters[0]);
comm.Parameters.Add(parameters[1]);
comm.ExecuteNonQuery();
}
-----------------
我跟踪到“comm.ExecuteNonQuery();”提示如下错误:
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'L./囨堾惼畯汪郆( 谑攻~V?xI?儈^H|Az€岪?憠Jtl?問x泏?焅0梊\WI?甿' at line 1