Click here to Skip to main content
Click here to Skip to main content

Populating data from a CSV file to a DataGridView and Retriving data from a DataGridView to CSV

, 30 Dec 2006 CPOL
Rate this:
Please Sign up or sign in to vote.
Populating data from a CSV file to a DataGridView and Retriving data from a DataGridView to CSV



I had problems finding a decent article that showed how to Populate a Datagridview from CSV file and how to store information from DataGridView to a CSV file.

This article is compilation of two sources from the internet.  First one is and the second one is


There is one Form having default name Form1 

There is one DataGridView named DataGridView1

Two buttons named Button1 and Button2

One Textbox named Textbox1

The csv file contains information as follows (between the inverted commas):






Remove inverted commas if you are copying directly from here


The sourcecode behind the form is


Public Class Form1

Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click

Dim fName As String = ""

OpenFileDialog1.InitialDirectory = "c:\temp\"

OpenFileDialog1.Filter = "CSV files (*.csv)|*.CSV"

OpenFileDialog1.FilterIndex = 2

OpenFileDialog1.RestoreDirectory = True

If (OpenFileDialog1.ShowDialog() = Windows.Forms.DialogResult.OK) Then

fName = OpenFileDialog1.FileName

End If

Me.TextBox1.Text = fName

Dim TextLine As String = ""

Dim SplitLine() As String


If System.IO.File.Exists(fName) = True Then

Dim objReader As New System.IO.StreamReader(fName)

Do While objReader.Peek() <> -1

TextLine = objReader.ReadLine()

SplitLine = Split(TextLine, ",")




MsgBox("File Does Not Exist")

End If

End Sub


Private Sub SaveGridDataInFile(ByRef fName As String)

Dim I As Integer = 0

Dim j As Integer = 0

Dim cellvalue$

Dim rowLine As String = ""


Dim objWriter As New System.IO.StreamWriter(fName, True)

For j = 0 To (DataGridView1.Rows.Count - 2)

For I = 0 To (DataGridView1.Columns.Count - 1)

If Not TypeOf DataGridView1.CurrentRow.Cells.Item(I).Value Is DBNull Then

cellvalue = DataGridView1.Item(I, j).Value


cellvalue = ""

End If

rowLine = rowLine + cellvalue + ","



rowLine = ""



MsgBox("Text written to file")

Catch e As Exception

MessageBox.Show("Error occured while writing to the file." + e.ToString())



End Try

End Sub


Private Sub Button2_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button2.Click


End Sub

End Class

End Source code

If you have any queries e-mail me and I will do my best to help.



This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)


About the Author

Australia Australia
I started with C and then my Professor introduced C++ and I was thrilled. Then when I was working for an Engineering firm, I was introduced to VB6 by one of my friend (and till day I am thankful to him). My love for 3D graphics made me learn 3D studio max but left it and started learning OpenGL. Frustrated with it when I couldn't work with OpenGL in VB6 and properly, I switched to DirectX. I am learning it for sometimes and will be looking forward to it. Currently I started working on developing Pipe StressAnalysis software.

Comments and Discussions

QuestionHow to add csv data to DataGridView using VB 2010? PinmemberMember 1036332728-Oct-13 17:08 
GeneralMy vote of 5 Pinmemberandyjohnwhite10-Sep-12 8:01 
GeneralData from txt file [modified] Pinmembersolfinker22-Apr-11 1:30 
GeneralImport csv to database PinmemberAnthony Fonseca21-Mar-11 7:43 
GeneralMy vote of 5 PinmemberAnthony Fonseca16-Mar-11 16:31 
Generaljust what the doctor recommended Pinmembergiovetti25-Feb-11 6:07 
GeneralThis is really really great Pinmembersolfinker29-Jan-11 9:10 
GeneralRe: This is really really great PinmemberDharmit29-Jan-11 16:46 
GeneralRe: This is really really great Pinmembersolfinker29-Jan-11 22:01 
GeneralRe: This is really really great Pinmembersolfinker30-Jan-11 0:00 
QuestionError Details. Pinmembersamvaidy10-Mar-10 8:30 
AnswerRe: Error Details. PinmemberDharmit10-Mar-10 12:24 
GeneralThank you! PinmemberElizabeth Tweedale7-Oct-09 1:05 
QuestionDatagridview Validation PinmemberMatikule7-Nov-08 4:48 
GeneralReading a CSV into a DataGridView PinmemberFilemon Tanchoco14-Jun-08 19:25 
GeneralRe: Reading a CSV into a DataGridView PinmemberDharmit15-Jun-08 1:07 
GeneralGreat Code - Exactly what I was looking for. Pinmemberbaillie1114-May-08 23:27 
GeneralRe: Great Code - Exactly what I was looking for. PinmemberDharmit15-Jun-08 1:08 
QuestionThis Doesn't Work Pinmemberjcviera19-Jan-07 7:18 
AnswerRe: This Doesn't Work Pinmembervishal_chauhan21-Jun-07 7:43 
GeneralGreat PinmemberMarwa ElBadry2-Jan-07 21:06 
GeneralRe: Great PinmemberDharmit3-Jan-07 0:33 
GeneralRe: Great PinmemberKwazai4-Jan-07 3:10 
GeneralRe: Great PinmemberLuca Crisi, MCP21-Dec-08 19:23 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.

| Advertise | Privacy | Mobile
Web03 | 2.8.141022.2 | Last Updated 30 Dec 2006
Article Copyright 2006 by Dharmit
Everything else Copyright © CodeProject, 1999-2014
Terms of Service
Layout: fixed | fluid