I upload world document and insert name and bytes of doc into database.
When i insert recoed into database i got this error on ExecuteNonQuery: String or binary data would be truncated. The statement has been terminated.
This error is due to insert Fileytes field.
Con= new SqlConnection(ConStr);
cmd= new SqlCommand("INSERT INTO Files(FileName,FileBytes) VALUES (@FileName,@FileBytes)",Con);
cmd.Parameters.AddWithValue("@FileName", upFile.FileName);
cmd.Parameters.AddWithValue("@FileBytes", upFile.FileBytes);
Con.Open();
cmd.ExecuteNonQuery();
Con.Close();
Database table is like
id int
FileName varchar(50)
FileBytes varbinary(max)
Waiting for reply.
Thanks in advance