新建了LONGBLOB字段,上传了只有90M的文件就提示System.OutOfMemoryException,电脑内存肯定不止这一点。
public bool inBase(string file, string conStr, string code)
{
bool isComplete = true;
MySqlConnection conn = new MySqlConnection();
MySqlCommand cmd = new MySqlCommand();
string SQL = "INSERT INTO file_table VALUES(@Code, @FileName, @FileSize, @File)";
conn.ConnectionString = conStr;
try
{
FileStream fs = new FileStream(file, FileMode.Open, FileAccess.Read);
long FileSize = fs.Length;
byte[] rawData = new byte[FileSize];
fs.Read(rawData, 0, (int)FileSize);
fs.Close();
conn.Open();
cmd.Connection = conn;
cmd.CommandText = SQL;
cmd.Parameters.AddWithValue("@Code", code);
cmd.Parameters.AddWithValue("@FileName", Path.GetFileName(file));
cmd.Parameters.AddWithValue("@FileSize", FileSize);
cmd.Parameters.AddWithValue("@File", rawData);
cmd.ExecuteNonQuery();
conn.Close();
}
catch
{ isComplete = false; }
return isComplete;
}