I am trying to find a way to import comma delimited data into a SQL Server database via a textarea form field using ASP.NET.
Here is some background. I work for a school and I am trying to setup an online application where instructors can easily transfer student grades from a grade book application into an online database using a web form. I already created the online database and have ASP.NET pages setup for viewing and searching records. Now I just need the web form where the instructors paste the delimited data and hit submit to import it into the database.
The delimited data that would get pasted into the textarea field looks something like this:
"Smtih, John",3434983,Fall 2005,HIST 101,A
"Rosenberg, Greg",3434984,Fall 2005,HIST 101,B
"Hall, John",3434985,Fall 2005,HIST 101,B+
"Perry, Joan",3434986,Fall 2005,HIST 101,C
"Lemke, Adrian",3434987,Fall 2005,HIST 101,C-
"Nguen, Jennifer",3434988,Fall 2005,HIST 101,D
"Arlan, Smantha",3434989,Fall 2005,HIST 101,A
"Jimenez, Damian",3434990,Fall 2005,HIST 101,B
Here are details on the database where it will be imported:
Database name: GradeArchive
Field/column names that correspond to delimited text to import:
Any help would be greatly appreciated.