I am working on my project and trying to upload videos into the data base. but it gives me the error....
protected void Button1_Click(object sender, EventArgs e)
{
if (FUVideo.PostedFile != null)
{
FileName = Path.GetFileName(FUVideo.PostedFile.FileName);
FUVideo.SaveAs(Server.MapPath("~/Images/" + FileName));
videosize = FUVideo.PostedFile.ContentLength;
videotype = FUVideo.PostedFile.ContentType;
}
try
{
db1.sqlcmd = new SqlCommand("uspAddVideos");
using (SqlDataAdapter sda = new SqlDataAdapter())
{
db1.sqlcmd.CommandType = CommandType.StoredProcedure;
db1.sqlcmd.Parameters.AddWithValue("@UserID", UserID);
db1.sqlcmd.Parameters.AddWithValue("@SubscripID", SubscripID);
db1.sqlcmd.Parameters.AddWithValue("@Title", Convert.ToString(TBVname.Text.Trim()));
db1.sqlcmd.Parameters.AddWithValue("@Details", Convert.ToString(TBVDesc.Text.Trim()));
db1.sqlcmd.Parameters.AddWithValue("@Category", Convert.ToString(TBCategory.Text.Trim()));
db1.sqlcmd.Parameters.AddWithValue("@Name", FileName);
db1.sqlcmd.Parameters.AddWithValue("@Url", "~/Images/" + FileName);
db1.sqlcmd.Parameters.Add("@success", SqlDbType.Bit);
db1.sqlcmd.Parameters["@success"].Direction = ParameterDirection.Output;
db1.sqlcmd.Connection = db1.sqlcon;
db1.sqlcon.Open();
db1.sqlcmd.ExecuteScalar();
success = (bool)db1.sqlcmd.Parameters["@success"].Value;
}
}
catch (Exception ex)
{
Response.Write(ex.Message);
}
finally
{
if (success == true)
{
db1.sqlcon.Close();
}
else
{
}
db1.sqlcon.Close();
}
}
Create Proc uspAddVideos
@success bit out,
@Name nvarchar(max),@Title nvarchar(100), @Details varchar(250),
@Url varchar(max),@Category varchar(50), @SubscripID int,@UserID int
AS
BEGIN
SET NOCOUNT ON;
BEGIN TRY
INSERT INTO TblVideos (Title,Name, Url, Details, Category, PublishedOn, PublishedBy,SubcriptionId)
VALUES (@Title,@Name,@Url, @Details,@Category,GETDATE(),@UserID,@SubscripID)
UPDATE TblSubscription SET MaxVideos = MaxVideos -1 WHERE SubscriptionId = @SubscripID
SET @success = 1
END TRY
BEGIN CATCH
SET @success = 0
END CATCH
END
and the error is.....
Maximum request length exceeded.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.Web.HttpException: Maximum request length exceeded.