Get Data From CSV to MS SQL DB

Hi, i have been trying to find information about this problem to no avail,:

I have a csv file already created which i would like to insert into my database line by line.

Would it be possible for someone to show me an example of how to change the following so i can insert it into my database..???

~Many thanks for your help i am soooo stuck with this.. i am learning vb.net and sql and finding it really hard to get any real examples to help me learn.

The CSV is as follows there are

filename,filesize,modifieddate,fileversion,package ditem

Filename1,3061,17/01/2006 09:57:49,,
Filename2,157696,25/01/2006 07:57:02,,
Filename3,206,25/01/2006 14:11:17,,
Filename4,244,25/01/2006 08:27:39,,

the table is as follows:

CI_ID,BuildID,filename,filesize,modifieddate,filev ersion,packageditem

The CI_ID is the identity and the BuildId is a sep Parameter from a combobox selected value.

If anyone can help me i would be most grateful

Lost

no takers??

I could r3eally do with the help please anyone?

Or how about from a dataset / datagrid to database? in VB.NET??

Do you have to do this via a webpage?

hi thanks for your reply...

no its going from a windows application.... written in vb.net.... i am sooo lost with this... i have had a bit of mind meltdown...lol so any help will be greatly received....