Question Uploading CSV to Sql Server Table

[GingJonesy]

Im new to this and Im creating a asp.net website that will allow you to upload a csv file with the following names and data types to a table called product_backlog which is on sql server:

UserStoryID int
UserStoryPriority int
UserStory varchar(MAX)
UserStoryEstimate varchar(50)
ProjectName varchar(50)

The file must only be .csv format and the contents of the file must be inserted into the product_backlog table, also the filename of the csv file may be different each time it is uploaded.

I am clueless on how to do this or even how to start it, anybody able to help me out??

 

[GingJonesy]

Also forgot to say UserStoryID is auto incremented so each new userstory it will go up by 1, and also UserStoryID and ProjectName are primary keys

 

[cjard]

Upload CSV file to SQL Server in VB

nothing mystical about the above component (proprietary) as this blog shows you can use an MS provided lib for a similar thing:
<link href="../../../../App_Themes/Default/Blog.css" type="text/css" rel="stylesheet" /><title> Éric Moreau's blog : Do you know the TextFieldParser?

 

[GingJonesy]

Had a look at that link however i cant use that csvreader in the project im doing