Routine: Asp.net saves the large file to the image field of MSSQL and displays the progress information in real time.

When saving large files to MSSQL in Asp.net, the following two key problems need to be solved:

1. Files must be stored in MSSQL in multiple parts;
2. When the file is large, it takes a long time to save the file to MSSQL. The ASP. NET page may encounter a timeout error and cause the operation to fail.

The following two articlesArticleThe above two problems are well solved:

1. How to read and write a file to and from a blob column by using chunking In ADO. NET and Visual C #. net
2. Executing long running operations-Part II

Article 1 solves the problem of time-out errors caused by processing tasks for a long time using multiple threads. This article provides a practical example based on the above two documents for your reference.
Routine download: http://files.cnblogs.com/bestcomy/FileToMSSQL.rar

Routine installation steps:

1. Decompress filetomssql.rar and set the decompressed folder to a virtual directory;
2. Make sure that you have a connectable MSSQL with the northwind database. In this example, the categories data table is used;
3. Make sure that the connstr database connection string in the <etettings> Configuration section of Web. config In the example is correct, which corresponds to your own MSSQL environment.
4. Unexpectedly, you can use this routine to access default. aspx under the filetomssql virtual directory through IE.