load a text file into data grid view in window application

Question

0.00/5 (No votes)

See more:

hello
i want to load a text file in this file first row is "Column Header" and other data row and data Separator with "," how i can load a text file into datagrid view using c# window application. Plz Reply me

Thanks

Posted 11-Apr-12 6:59am

i2u2me

Add a Solution

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

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

Reza Ahmadi · Answer 1 · 2012-04-11T07:14:00

Solution 2

Hi,
You can iterate through your file and then add them to a DataTable. then, you can bind the DataTable to your DataGridView.
A post to read a text file:
http://www.csharp-station.com/HowTo/ReadWriteTextFile.aspx[^]
A post about DataTable:
http://www.dotnetperls.com/datatable[^]

I hope it helps,
Cheers

Posted 11-Apr-12 7:14am

Reza Ahmadi

Comments

VJ Reddy 11-Apr-12 13:24pm

Good links. 5!

Reza Ahmadi 11-Apr-12 13:39pm

Thanks!

VJ Reddy · Answer 2 · 2012-04-11T07:14:00

The data contained in the text file in the format specified in the question can be read into a DataTable and the DataTable can be bound to a DataGridView using the following code

C#

void Main()
{
	Form form1 = new Form();
	DataGridView dataGridView1 = new DataGridView();
	dataGridView1.Dock= DockStyle.Fill;

        //Read the data from text file
	string[] textData = System.IO.File.ReadAllLines(dataFileName);
	string[] headers = textData[0].Split(',');

        //Create and populate DataTable
	DataTable dataTable1 = new DataTable();
	foreach(string header in headers)
	    dataTable1.Columns.Add(header,typeof(string),null);
	for(int i=1; i < textdata.length; i++)
            dataTable1.Rows.Add(textData[i].Split(','));

        //Set the DataSource of DataGridView to the DataTable
	dataGridView1.DataSource = dataTable1;
	form1.Controls.Add(dataGridView1);
	form1.ShowDialog();
}