How to show on a Datagrid from a Text file

Santosh Kumar

Hi All!

I want to copy a text file from another client system and copy it on our own system. In C drive I copy a text file but I unable to show it on the Datagrid. Please help me with full code. I am using C# windows application.

8 Replies

Know the answer? Post it — somebody with the same question will find it here.

Dorababu Meka15y ago
Santosh mark the one as answer which got you the solution
Santosh Kumar15y ago
Thank you so much.
Dorababu Meka15y ago
Hi have you gone through my article this will give you an idea about how to load a text file in to datagrdiview but as i have done that as per my requirement it will not accept every text file to have an idea go here

http://www.c-sharpcorner.com/UploadFile/Dorababu742/7452/?ArticleID=bddaae7d-d2c8-4393-9891-1d8411fc3abe
Mukesh Kumar15y ago
Step 1 > Add this class to your project
using System;
using System.Data;
using System.IO;

namespace TestTextToDataSet
{
public class TextToDataSet
{

public TextToDataSet()
{ }

///

/// Converts a given delimited file into a dataset.

/// Assumes that the first line

/// of the text file contains the column names.

///

/// The name of the file to open

/// The name of the

/// Table to be made within the DataSet returned

/// The string to delimit by

///

public static DataSet Convert(string File,
string TableName, string delimiter)
{
//The DataSet to Return

DataSet result = new DataSet();

//Open the file in a stream reader.

StreamReader s = new StreamReader(File);

//Split the first line into the columns

  string[] columns = s.ReadLine().Split(delimiter.ToCharArray());

//Add the new DataTable to the RecordSet

result.Tables.Add(TableName);

//Cycle the colums, adding those that don't exist yet

//and sequencing the one that do.

foreach (string col in columns)
{
bool added = false;
string next = "";
int i = 0;
while (!added)
{
//Build the column name and remove any unwanted characters.

string columnname = col + next;
columnname = columnname.Replace("#", "");
columnname = columnname.Replace("'", "");
  columnname = columnname.Replace("&", "");

//See if the column already exists

if (!result.Tables[TableName].Columns.Contains(columnname))
{
//if it doesn't then we add it here and mark it as added

result.Tables[TableName].Columns.Add(columnname);
added = true;
}
else
{
  //if it did exist then we increment the sequencer and try again.

i++;
next = "_" + i.ToString();
}
}
}

//Read the rest of the data in the file.

string AllData = s.ReadToEnd();

//Split off each row at the Carriage Return/Line Feed

//Default line ending in most windows exports.

//You may have to edit this to match your particular file.

//This will work for Excel, Access, etc. default exports.

string[] rows = AllData.Split("\r\n".ToCharArray());

//Now add each row to the DataSet

foreach (string r in rows)
{
//Split the row at the delimiter.

string[] items = r.Split(delimiter.ToCharArray());

//Add the item

result.Tables[TableName].Rows.Add(items);
}

//Return the imported data.

return result;
}
}
}
Step 2 > Add this namespace  to your working page
using TestTextToDataSet;

Step 3> Add this code to your working page.
DataSet ds = TextToDataSet.Convert( @"c:\TestImport.txt","MyNewTable", "\t");
if (ds.Tables[0].Rows.Count > 0)
{
  DataGridView1.DataSource = ds.Tables["MyNewTable"];
DataGridView1.DataBind();
}
Sam Hobbs15y ago
Murali's code looks good to me. Note that there are articles in this web site with other possibilities.

I hope you don't mind me saying that your avatar (or maybe it is called profile picture) animation is real cute but it is distracting for me. I don't know why.
15y ago
Try the below... you may need to enhace the below code... to read the data from instead of a string..

            string s = "Name=Rajan|EmpID=12345|Company Name=ABC|Address=ABCDE|PIN=110001";
            //string[] split = new string("|");
            char[] delimiters = new char[] { '|'};
            string[] items = s.Split(delimiters);
            delimiters = new char[] { '=' };
            string[] columns = null;
            DataTable dt = new DataTable();
            foreach(string str in items)
            {
                columns = str.Split(delimiters);
                dt.Columns.Add(new DataColumn(columns[0]));
            }
            //import the row
            DataRow dr = dt.NewRow();
            foreach (string str in items)
            {
                columns = str.Split(delimiters);
                dr[columns[0]] = columns[1];

            }
            dt.Rows.Add(dr);
            dataGridView1.AutoGenerateColumns = true;
            dataGridView1.DataSource = dt;

Hope this helps you,.
Santosh Kumar15y ago
The Fields are separeted by | such as
Name=Rajan|EmpID=12345|Company Name=ABC|Address=ABCDE|PIN=110001
and so on.
15y ago
Does the text file is comma delimitted (CSV), fixed length file ? How you can separate the columns in a particular line?