Import from text file to gridview

Question

0.00/5 (No votes)

See more:

I'm trying to import data from text file to grid view  using the blew code :

 

   
My file is like :

A B C

E F D C C 

E D D D

D P


Then I get the following error 
>Input array is longer than the number of columns in this table in c# application

What I have tried:

DataTable dt = new DataTable();
   using (System.IO.TextReader tr = File.OpenText((@"d:\\My File3.log")))
   {
       string line;
       while ((line = tr.ReadLine()) != null)
       {

           string[] items = line.Trim().Split(' ');
           if (dt.Columns.Count == 0)
           {
               // Create the data columns for the data table based on the number of items
               // on the first line of the file
               for (int i = 0; i < items.Length; i++)
                   dt.Columns.Add(new DataColumn("Column" + i, typeof(string)));
           }
           dt.Rows.Add(items);

       }
       //show it in gridview
       this.GridView1.DataSource = dt;
       this.GridView1.DataBind();

Posted 16-Apr-17 20:11pm

Member 12140172

Updated 16-Apr-17 20:54pm

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)

Michael_Davies · Accepted Answer · 2017-04-16T20:21:00

You state the problem in your comment, the number of columns is based on the length of the first line of the file, the second line is longer than the first and therefore there are not enough columns.

I have not tried this out and it might need a tweak but here is a rough fix;

C#

string[] items = line.Trim().Split(' ');
           if (dt.Columns.Count < items.Length)
           {
               for (int i = dt.Columns.Count; dt.Columns.Count <> items.Length; i++)
                   dt.Columns.Add(new DataColumn("Column" + i, typeof(string)));
           }

madhav_jain · Accepted Answer · 2017-04-16T20:54:00

First u need to get max column from file and create Datatable than loop it and show in Gridview. use below code

 DataTable dt = new DataTable();
            using (System.IO.TextReader tr = File.OpenText((@"C:\Users\madhav.jain\Desktop\ss.txt")))
            {
                string line;
//add new list of string arrey
                List<string[]> lststr = new List<string[]>();
                while ((line = tr.ReadLine()) != null)
                {

                    string[] items = line.Trim().Split(' ');
                    lststr.Add(items);
                }
                int col = lststr.Max(x => x.Length);
                if (dt.Columns.Count == 0)
                {
                    // Create the data columns for the data table based on the number of items
                    // on the first line of the file
                    for (int i = 0; i < col; i++)
                        dt.Columns.Add(new DataColumn("Column" + i, typeof(string)));
                }
// loop the list 
                foreach (string[] item in lststr)
                {
                    dt.Rows.Add(item);
                }


            }
                //show it in gridview 
                this.gv.DataSource = dt;
                this.gv.DataBind();

Import from text file to gridview

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0