create a csv file import utility that displays the imported data in a datagrid in csharp

Here's a simple implementation of a CSV file import utility that displays the imported data in a DataGridView.

First, you will need to add the following using directives to the top of your code file:

main.cs
using System;
using System.Data;
using System.IO;
using System.Windows.Forms;
78 chars
5 lines

Then, create a method that reads the CSV file and returns a DataTable object that holds the imported data. This method can be called when the user clicks a button, for example.

main.cs
private DataTable GetDataTableFromCsv(string path)
{
    DataTable dataTable = new DataTable();

    try
    {
        using (StreamReader reader = new StreamReader(path))
        {
            string[] headers = reader.ReadLine().Split(',');
            foreach (string header in headers)
            {
                dataTable.Columns.Add(header);
            }

            while (!reader.EndOfStream)
            {
                string[] rows = reader.ReadLine().Split(',');
                DataRow dataRow = dataTable.NewRow();
                for (int i = 0; i < headers.Length; i++)
                {
                    dataRow[i] = rows[i];
                }
                dataTable.Rows.Add(dataRow);
            }
        }
    }
    catch (Exception ex)
    {
        MessageBox.Show(ex.Message);
    }

    return dataTable;
}
845 chars
34 lines

This method takes a path parameter, which is the full file path of the CSV file to import. It reads the CSV file line by line, splits each line into an array of fields using comma as the delimiter, and adds each field to a DataRow object. The DataRow object is then added to a DataTable object.

Next, create a Button control on your form and add an event handler for the Click event. In this event handler, call the GetDataTableFromCsv method and pass the file path of the CSV file to import. Set the DataSource property of the DataGridView control to the DataTable object returned by the GetDataTableFromCsv method.

main.cs
private void btnImport_Click(object sender, EventArgs e)
{
    string path = @"C:\path\to\csvfile.csv";
    DataTable dataTable = GetDataTableFromCsv(path);
    dataGridView1.DataSource = dataTable;
}
201 chars
7 lines

Finally, run your application and click the button to import the CSV file. The imported data will be displayed in the DataGridView control.

Note: This implementation assumes that the CSV file has a header row that contains the column names. If your CSV file does not have a header row, you will need to modify the code accordingly.