ASP.NET Page in C# (SQL Server Upload)
$100-500 USD
Paid on delivery
Create ASP.NET page written in C# that will allow a user to upload a CSV file containing data in a fixed format (file format has been provided in the form of sample upload file) to a server for import into a Microsoft SQL database table.<span id="jwk2" goog_docs_charindex="2552">? </span>
## Deliverables
<p id="z:.t" goog_docs_charindex="2311">This job is to create an asp.net page that will be integrated into another application.?
Create ASP.NET page written in C# that will allow a user to upload a CSV file containing data in a fixed format (file format has been provided in the form of sample upload file) to a server for import into a Microsoft SQL database table.<span id="jwk2" goog_docs_charindex="2549">? </span> The designed page will support the following features.? <br id="w0o4" goog_docs_charindex="2608" /></p> <p id="z7mm" goog_docs_charindex="2610">? </p> <ol id="bagx" goog_docs_charindex="2613"> <li id="bln4" goog_docs_charindex="2614">Have a file upload control to allow user to select a CSV file from their computer and upload to server (uploaded file should not be stored on server but only in memory).</li> <li id="bln4" goog_docs_charindex="2785">Data in uploaded file should be stored in some manner (datatable, sql table) etc so that the users can review the file prior to finalizing the import.<span id="iw-7" goog_docs_charindex="2936">? </span> If the file does not match the specified format an error message shall be returned to the user.</li> <li id="bln4" goog_docs_charindex="3036">The users should be able to review the data to be uploaded and the following summary information should be provided to the user prior to finalizing the upload. <ul id="[url removed, login to view]" goog_docs_charindex="3197"> <li id="bln4" goog_docs_charindex="3198">Total Number of records to import<span id="bxs4" goog_docs_charindex="3232">? </span></li> <li id="bln4" goog_docs_charindex="3237">The data for review should be displayed all on one page (top 500 records at first with the option for the user to display all records)</li> <li id="bln4" goog_docs_charindex="3373">A “load data?? button should be located below that table of data for the user to review.<span id="ozye" goog_docs_charindex="3461">? </span> This button should load the data from the uploaded file into a Microsoft Sql Server 2005 table (table should be named "TestScores")</li> </ul> </li> </ol> <p id="wxey" goog_docs_charindex="3599">? </p> <p id="famb" goog_docs_charindex="3602"><br id="wxod" goog_docs_charindex="3603" /></p> <p id="pvpw" goog_docs_charindex="3605"><span id="h_j2" goog_docs_charindex="3606"><i id="gc0q" goog_docs_charindex="3607">Notes:</i></span><span id="yjkn" goog_docs_charindex="3616"><span id="qote" goog_docs_charindex="3617"><i id="ko-x" goog_docs_charindex="3618">? </i></span></span></p> <p id="l0va" goog_docs_charindex="3625">This application will have a number of different people uploading different files.<span id="pjyq" goog_docs_charindex="3710">? </span> All the files will have the same format and be stored in the same table.</p> <p id="tqyy" goog_docs_charindex="3787">? </p>
Project ID: #3831691