taking video's url to store in database takes too much time

Question

0.00/5 (No votes)

See more:

Hi,

I'm taking video's url with FileUpload control in asp .net . And then I add this url to database. But when I'm doing this operation, operation takes too much time and becomes fail without any error message. I'm doing same operation with same c# code and same database table with same field for images, it's working very well. I guess problem comes from IIS but I don't know how to solve it. Is there any idea or solution?

I use following code in web.config file:

<httpRuntime targetFramework="4.5" maxRequestLength="1048576" executionTimeout="3600"/>

Thanks.

Posted 13-Oct-12 23:19pm

bmyusuf

Add a Solution

4 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

bmyusuf · Answer 1 · 2012-10-15T01:48:00

Solution 4

I solved the problem with this code:

XML

<security>
    <requestFiltering>
        <requestLimits maxAllowedContentLength="1073741824" />
    </requestFiltering>
</security>

maxAllowedContentLength=&quot;1073741824

this is refer to 1GB file size.

Posted 15-Oct-12 1:48am

bmyusuf

srikanth pachava · Answer 2 · 2012-10-14T01:43:00

C#

protected void btnUpload_Click(object sender, EventArgs e)
       {
           HttpPostedFile file = File1.PostedFile;
           int intFileSize;
           filepath = @"Upload\";
           filetype = "";
           intupload = 0;

           if (file.FileName != "")
           {
               filename = GetFileName(file);

              intFileSize = Convert.ToInt32(file.ContentLength);
              if (intFileSize < 500000)
              {
                  if (file.ContentType.IndexOf("text/plain") >= 0)
                  {
                      file.SaveAs(Server.MapPath(@"\Upload\" + filename));
                      filepath = filepath + filename;
                      filetype = @"text/plain";
                      lblMsge.Text = filename + " File uploaded";
                      intupload = 1;
                      //UsrCallog ucal = new UsrCallog();
                      //ucal.insupload(
                  }

********************************

C#

private string GetFileName(HttpPostedFile file)
      {
          int i = 0, j = 0;
          string strAttCnt;
          string filename;

          filename = file.FileName;
          do
          {
              i = filename.IndexOf(@"\", j + 1);
              if (i >= 0) j = i;
          } while (i >= 0);
          filename = filename.Substring(j + 1, filename.Length - j - 1);

          conn = (string)ConfigurationSettings.AppSettings["cnStr"];
          using (cn = new SqlConnection(conn))
          {
              using (cmd = new SqlCommand("select count(*) from tblusrsol where attach =1", cn))
              {
                  cmd.CommandType = CommandType.Text;
                  cn.Open();
                  strAttCnt = cmd.ExecuteScalar().ToString();
                  cn.Close();
              }
          }

          return strAttCnt + filename;

      }

******************************************

after uploading i am saving the path on the label and after inserting it into database.

srikanth pachava · Answer 3 · 2012-10-14T00:02:00

Solution 2

did you checked the enableviewstate option in @page is set to true or false if it is true then make it false.

Posted 14-Oct-12 0:02am

srikanth pachava

Comments

bmyusuf 14-Oct-12 7:09am

I did your solution then I take an HTTP Error 404.13 error message. I solved the error which explain in this link: http://support.microsoft.com/kb/942074. After I solved the error then I returned the same problem. So problem didn't solve.

srikanth pachava · Answer 4 · 2012-10-13T23:32:00

Solution 1

SQL

Hi,

just create a folder named upload in inetpub->wwwroot. save the file in that folder when you upload a file.

Posted 13-Oct-12 23:32pm