iXora Custom Software Development Blog

Read | Practice | Advance

Harun Or Rashid

Harun Or Rashid

Harun Or Rashid has not set their biography yet

Normally We can't upload files of  size > 4 MB. If we have to upload file of size maximum 4 GB then the web.config file must be contained the following codes <configuration> </system.web> <httpRuntime maxRequestLength="4124672" requestValidationMode="2.0" executionTimeout="36000" /> </system.web> <system.webServer> <security> <requestFiltering> <requestLimits maxAllowedContentLength="4223664128"></requestLimits> </requestFiltering> </security> </system.webServer> </configuration>  Notes:  maxRequestLength  in httpRuntime is KB (Kilo Bytes)  BUT  maxAllowedContentLength  in  requestLimits is B (Bytes) Reference: http://hrn2k1.blogspot.com/2012/06/tips-about-uploading-4-gb-file-on-web.html ...
Hits: 1165
Rate this blog entry:
0

Posted by on in Blog
Solution #1: SELECT * FROM ( SELECT TOP 3 ROW_NUMBER() OVER(ORDER BY DateOfBirth) AS row,* FROM Employee ) Emp WHERE row=3 Solution #2: SELECT TOP 1 * FROM ( SELECT TOP 3 * FROM Employee ORDER BY DateOfBirth ) Emp ORDER BY DateOfBirth DESC If any more solutions please comment....
Hits: 1243
Rate this blog entry:
0

We upload any type of files from client to server using html element

<input id='myFile' type="file" />

And using ASP.NET control

<asp:FileUpload ID='myFile' runat="server" />
Hits: 1189
Rate this blog entry:
1