Import data from a text file into a datagrid view

Question

Import data from a text file into a datagrid view

AMER SAID 396

hi

I have a text file with a number of rows in the following format for each row.

"id":"CumtJt6BpbJbTcDFhrE0Lw_0000","full_name":"hasmukh "

Where the first syllable is the name of the column and the second is the cell inside each column.
This is a simple sample file with more than 300 columns and thousands of rows. This is a sample for clarification

I would like to display the data in a DataTable or DataGrid View, since the data is undefined and so are the rows

id full_name
CumtJt6BpbJbTcDFhrE0Lw_0000" hasmukh

Viorel 122.6K Reputation points

2023-01-02T14:35:49.26+00:00

Maybe your real file contains rows like { "id":"CumtJt6BpbJbTcDFhrE0Lw_0000","full_name":"hasmukh " , . . . }. In this case you can use JSON functions.

Check if your file is actually a JSON that contains the specific "{ }" and "[ ]" characters.

AMER SAID 396

I tried to apply Jison to the previous file format, but it failed.
Data extracted from sites like this .enter code here my try after edit jason to txt line

public DataTable GetDataTableFromJsonString(string json)
{
var jsonLinq = JObject.Parse(json);

        // Find the first array using Linq  
        var srcArray = jsonLinq.Descendants().Where(d => d is JArray).First();  
        var trgArray = new JArray();  
        foreach (JObject row in srcArray.Children<JObject>())  
        {  
            var cleanRow = new JObject();  
            foreach (JProperty column in row.Properties())  
            {  
                // Only include JValue types  
                if (column.Value is JValue)  
                {  
                    cleanRow.Add(column.Name, column.Value);  
                }  
            }  
            trgArray.Add(cleanRow);  
        }  

        return JsonConvert.DeserializeObject<DataTable>(trgArray.ToString());  
    }  
    private void button2_Click(object sender, EventArgs e)  
    {  
         

        StreamReader stRead = new StreamReader(@"E:\\New Text Document.txt");  
        DataTable dataTable = GetDataTableFromJsonString(stRead.ReadToEnd());  
        dataGridView1.DataSource = dataTable;  
        //dataGridView1.DataBindings();  

    }

Accepted answer

0 additional answers

Your answer

Viorel 122.6K Reputation points

2023-01-02T14:35:49.26+00:00

Maybe your real file contains rows like { "id":"CumtJt6BpbJbTcDFhrE0Lw_0000","full_name":"hasmukh " , . . . }. In this case you can use JSON functions.

Check if your file is actually a JSON that contains the specific "{ }" and "[ ]" characters.
AMER SAID 396 Reputation points

2023-01-02T18:38:16.267+00:00

I tried to apply Jison to the previous file format, but it failed.
Data extracted from sites like this .enter code here my try after edit jason to txt line

public DataTable GetDataTableFromJsonString(string json)
{
var jsonLinq = JObject.Parse(json);

// Find the first array using Linq var srcArray = jsonLinq.Descendants().Where(d => d is JArray).First(); var trgArray = new JArray(); foreach (JObject row in srcArray.Children<JObject>()) { var cleanRow = new JObject(); foreach (JProperty column in row.Properties()) { // Only include JValue types if (column.Value is JValue) { cleanRow.Add(column.Name, column.Value); } } trgArray.Add(cleanRow); } return JsonConvert.DeserializeObject<DataTable>(trgArray.ToString()); } private void button2_Click(object sender, EventArgs e) { StreamReader stRead = new StreamReader(@"E:\\New Text Document.txt"); DataTable dataTable = GetDataTableFromJsonString(stRead.ReadToEnd()); dataGridView1.DataSource = dataTable; //dataGridView1.DataBindings(); }

Answer 1

@AMER SAID , Welcome to Microsoft Q&A, you could use string.split and linq method to import data from a text file into a datagridview.

private void button1_Click(object sender, EventArgs e)  
{  
    var lines= File.ReadAllLines("test.txt");  

    var list = (from m in lines.ToList()  
               select new Example  
               {  
                   id = m.Split(new string[] { ",", ":" }, StringSplitOptions.None)[1].Replace("\"", ""),  
                   full_name = m.Split(new string[] { ",", ":" }, StringSplitOptions.None)[3].Replace("\"", ""),  
               }).ToList();  
    dataGridView1.DataSource = list;  
      

}  


public class Example  
    {  
        public string id { get; set;}  
  
        public string full_name { get; set;}  
    }

Result:

Best Regards,
Jack

If the answer is the right solution, please click "Accept Answer" and upvote it.If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Share via

Import data from a text file into a datagrid view

0 additional answers

Your answer