http://www.programmersheaven.com/ Contains the latest posts from the thread 'Uploading Csv and inserting to Database' posted on the 'ASP.NET' forum at Programmer's Heaven. en Copyright 2013 Programmers Heaven Thu, 20 Jun 2013 02:05:37 -0700 Thu, 20 Jun 2013 02:05:37 -0700 Argotic Syndication Framework 2007.3.0.1, http://www.codeplex.com/Argotic http://www.rssboard.org/rss-specification 360 http://www.programmersheaven.com/images/ph.gif http://www.programmersheaven.com/ 88 31 http://www.programmersheaven.com/mb/ASPNET/426017/426017/uploading-csv-and-inserting-to-database/ Im new to this and Im creating a asp.net website that will allow you to upload a csv file to a specified folder in the site and the contents of the csv file will be inserted into a table called product_backlog on sql server. Below is the following names and data types that are in the product_backlog table: <br /> <br /> UserStoryID int <br /> UserStoryPriority int <br /> UserStory varchar(MAX) <br /> UserStoryEstimate varchar(50)<br /> ProjectName varchar(50)<br /> <br /> 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.<br /> <br /> UserStoryID is auto incremented so each new userstory inserted it will go up by 1, and also UserStoryID and ProjectName are primary keys.<br /> <br /> I have no idea at all how to attempt this, i need the code for the .VB part of the page and dont know how to start or what to write. Does anybody have any code that would do this for me, or that would help me????<br /> <br /> http://www.programmersheaven.com/mb/ASPNET/426017/426017/uploading-csv-and-inserting-to-database/ Thu, 01 Dec 2011 06:27:47 -0700 ASP.NET