S
- Steve -
I have the following function that is supposed to save a file to a SQL server. It works fine when the file is under about 5mb, but bigger than that and after I hit submit (which eventually fires off this function) it get a 400 page error.
private void btnUpload_Click(object sender, System.EventArgs e)
{
HttpPostedFile myFile = fileUpload.PostedFile;
byte[] myFileData = new byte[myFile.ContentLength];
myFile.InputStream.Read(myFileData, 0, myFile.ContentLength);
string fileName = Path.GetFileName(myFile.FileName);
SaveFileToSQL(fileName, myFile.ContentType, ref myFileData);
}
private string SaveFileToSQL(string fileName, string fileType, ref byte[] fileData)
{
SqlConnection myConnection = new SqlConnection(<connection details>)
SqlDataAdapter myDataAdapter = new SqlDataAdapter("SELECT * FROM FileX", myConnection);
SqlCommandBuilder myCommandBuilder = new SqlCommandBuilder(myDataAdapter);
myConnection.Open();
DataSet myDataSet = new DataSet();
myDataAdapter.Fill(myDataSet, "FileX");
DataTable myDataTable = myDataSet.Tables["FileX"];
//insert data into SQL
DataRow myDataRow = myDataTable.NewRow();
myDataRow["FileName"] = fileName;
myDataRow["FileSize"] = fileData.Length;
myDataRow["ContentType"] = fileType;
myDataRow["FileData"] = fileData;
myDataTable.Rows.Add(myDataRow);
myDataAdapter.Update(myDataSet, "FileX");
myConnection.Close();
}
--
Steve Evans
Email Services
SDSU Foundation
(619) 594-0708
private void btnUpload_Click(object sender, System.EventArgs e)
{
HttpPostedFile myFile = fileUpload.PostedFile;
byte[] myFileData = new byte[myFile.ContentLength];
myFile.InputStream.Read(myFileData, 0, myFile.ContentLength);
string fileName = Path.GetFileName(myFile.FileName);
SaveFileToSQL(fileName, myFile.ContentType, ref myFileData);
}
private string SaveFileToSQL(string fileName, string fileType, ref byte[] fileData)
{
SqlConnection myConnection = new SqlConnection(<connection details>)
SqlDataAdapter myDataAdapter = new SqlDataAdapter("SELECT * FROM FileX", myConnection);
SqlCommandBuilder myCommandBuilder = new SqlCommandBuilder(myDataAdapter);
myConnection.Open();
DataSet myDataSet = new DataSet();
myDataAdapter.Fill(myDataSet, "FileX");
DataTable myDataTable = myDataSet.Tables["FileX"];
//insert data into SQL
DataRow myDataRow = myDataTable.NewRow();
myDataRow["FileName"] = fileName;
myDataRow["FileSize"] = fileData.Length;
myDataRow["ContentType"] = fileType;
myDataRow["FileData"] = fileData;
myDataTable.Rows.Add(myDataRow);
myDataAdapter.Update(myDataSet, "FileX");
myConnection.Close();
}
--
Steve Evans
Email Services
SDSU Foundation
(619) 594-0708