How to import csv file data into DataGridView in load function

Question

1.00/5 (2 votes)

See more:

In my programme i want to import my csv file data into my datagridview into my load function,

I have no idea how to write the code for it.

here is my code:

C#

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;
using System.IO;
using VMwareRemoteConsoleTypeLib;

namespace OVF_ImportExport
{
    public partial class Form1 : Form
    {
        string sPath="";
        string sName = "";
        string delimiter = ",";
        string tablename = "export";
        public Form1()
        {
            InitializeComponent();
        }

        private void Form1_Load(object sender, EventArgs e)
        {

           string filename= ("c:\\izaz\\test.csv");
            DataSet dataset = new DataSet();
            StreamReader sr = new StreamReader(filename);
            string allData = sr.ReadToEnd();
            string[] rows = allData.Split("\r".ToCharArray());
            foreach (string r in rows)
            {
                string[] items = r.Split(delimiter.ToCharArray());
                dataset.Tables[tablename].Rows.Add(items);
            }
            this.dataGridView1.DataSource = dataset.Tables[0].DefaultView;

                 
            
            //System.Data.OleDb.OleDbConnection MyConnection;
            //System.Data.DataSet DtSet;
            //System.Data.OleDb.OleDbDataAdapter MyCommand;
            //MyConnection = new System.Data.OleDb.OleDbConnection(@"provider=Microsoft.ACE.OLEDB.12.0;Data Source='C:\psave\New folder\result.xlsx';Extended Properties=Excel 8.0;");
           // MyCommand = new System.Data.OleDb.OleDbDataAdapter("select * from [Sheet1$]", MyConnection);
           // MyCommand.TableMappings.Add("Name", "Path");
            //DtSet = new System.Data.DataSet();
            //MyCommand.Fill(DtSet);
            //dataGridView1.DataSource = DtSet.Tables[0];
            //MyConnection.Close();
            //dataGridView1.Columns[0].Width = 300;
            //dataGridView1.Columns[1].Width = 450;
        }

        private void dataGridView1_CellMouseClick(object sender, DataGridViewCellMouseEventArgs e)
        {
            
            foreach (DataGridViewRow row in dataGridView1.SelectedRows)
            {
                sName = row.Cells[0].Value.ToString();
                sPath = row.Cells[1].Value.ToString();

                           
            }
        }

        private void BtnBrowse_Click(object sender, EventArgs e)
        {
            fbd.ShowDialog();
            TxtBrowsepath.Text = fbd.SelectedPath;
        }

        private void BtnCreate_Click(object sender, EventArgs e)
        {
            richTextBox1.Text = "";
            StreamWriter file = new StreamWriter("Export.bat");
            file.WriteLine("c: ");
            file.WriteLine("cd \\");
            file.WriteLine("cd Program Files " );
            file.WriteLine("cd VMware" );
            file.WriteLine("cd VMware OVF Tool" );

            foreach (DataGridViewRow row in dataGridView1.SelectedRows)
            {
                sName = row.Cells[0].Value.ToString();
                sPath = row.Cells[1].Value.ToString();

                //richTextBox1.Text = richTextBox1.Text + Environment.NewLine + sName;
                file.WriteLine("start ovftool.exe --powerOffSource vi://"+TxtUsername.Text + ":" + TxtPassword.Text + "@"+ TxtIP.Text + sPath + " " + "\"" + TxtBrowsepath.Text + "\\" + sName + "\\"+ sName + ".ovf" + "\"" + Environment.NewLine);
                   
                
            }
            file.WriteLine("pause");
            file.Close();
        }

        private void BtnClose_Click(object sender, EventArgs e)
        {
            this.Close();
        }
        
        }
        
        }

Posted 29-Jun-15 22:53pm

Shaik Izaz

Updated 30-Jun-15 2:49am

v3

Add a Solution

Comments

Ralf Meier 30-Jun-15 5:15am

I don't see, where the posted code is corresponding to your question.
In fact, you "only" have to read the lines of your CSV-File and ADD the Contents (perhaps as row) to the DGV ...

Shaik Izaz 30-Jun-15 5:21am

i dint get you

Ralf Meier 30-Jun-15 6:09am

Your Question was : import the data from a CSV-File to a DGV.
Your posted Code is how to write data from the DGV to a CSV-File.

So : how does your code match to your question ...?

Shaik Izaz 30-Jun-15 6:58am

you are right! Actually, i was able to import xlsx file to DGV from load function and now i want to import csv file, so that why i just removed the xlsx import code from the load function and posted the full code....

Ralf Meier 30-Jun-15 8:03am

But ... if you are able to import data from Excel-Files you must also be able to do that from CSV-Files. The File-reading-method is different - but the assignment to the DGV must be the same (for the same data).

Shaik Izaz 30-Jun-15 8:12am

i dont know how to import from csv to DGV can you write me an exam example

Ralf Meier 30-Jun-15 8:18am

OK ... submit your CSV-Reader-method (improve your Question on the top) and I complete it for writing the data to DGV ...

Shaik Izaz 30-Jun-15 8:30am

i have change my question and i had wrote my code to import CSVfile to DGV which is not working(actually i took it from the net) because i have no idea how to import csv file into data grid view.
Please check the code in load function - private void Form1_Load(object sender, EventArgs e)

[no name] 30-Jun-15 9:35am

Unless you are willing to share some sort of a problem then I am not seeing where the question is. You have code that you apparently copied/pasted from somewhere and you don't know what it does?

Shaik Izaz 30-Jun-15 9:37am

the reason why i did is because i dont have any idea how to import csv file to DGV and moreover am new to c#

Ralf Meier 1-Jul-15 3:12am

At first : I agree with Wes ...

What you have to do is :
1. open the CSV-File (for Reading)
2. read the rows from the CSV-File - perhaps you iterate until you reach the EndOfFile
3. split the row into it's column-parts - for this you need to know the delimiter-character
4. transfer the (for you) interesting entries to your DGV - perhaps not all are interesting for you

It isn't a problem to teach this - but to be successful with this it is necessary that you do "some" work too - not me (or anyone else) alone

Ralf Meier 2-Jul-15 0:55am

and now ...?
Problem solved ...?

Shaik Izaz 2-Jul-15 3:46am

I tried like this and its solved

private void button1_Click(object sender, EventArgs e)
{
string delimiter = ",";
string tablename = "export";
string filename = ("c:\\izaz\\test.csv");

DataSet dataset = new DataSet();
StreamReader sr = new StreamReader(filename);

dataset.Tables.Add(tablename);
dataset.Tables[tablename].Columns.Add("Name");
dataset.Tables[tablename].Columns.Add("Path");
string allData = sr.ReadToEnd();
string[] rows = allData.Split("\r".ToCharArray());
foreach (string r in rows)
{
string[] items = r.Split(delimiter.ToCharArray());
dataset.Tables[tablename].Rows.Add(items);
}
this.dataGridView1.DataSource = dataset.Tables[0].DefaultView;

}

1 solution

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)

Sanpath Sunggad · Answer 1 · 2015-06-30T04:13:00

I have used solution like this, i hope this will work for you.
Import Data from Text and CSV file to DataGridView
STEP 1 : First i put the code in Button click event this will Browse your .csv in your computer, you can change to load function.

C#

OpenFileDialog fdlg = new OpenFileDialog();
    fdlg.Title = "Select file";
    fdlg.InitialDirectory = @"c:\";
    fdlg.FileName = txtFileName.Text;
    fdlg.Filter = "Text and CSV Files(*.txt, *.csv)|*.txt;*.csv|Text Files(*.txt)|*.txt|CSV Files(*.csv)|*.csv|All Files(*.*)|*.*";
    fdlg.FilterIndex = 1;
    fdlg.RestoreDirectory = true;
    if (fdlg.ShowDialog() == DialogResult.OK)
    {
        txtFileName.Text = fdlg.FileName;
        Import();
        Application.DoEvents();
    }

STEP 2 : Create Import function(), this used in STEP 1

C#

if (txtFileName.Text.Trim() != string.Empty)
{
    try
    {
        DataTable dt = GetDataTable(txtFileName.Text);
        dataGridView1.DataSource = dt.DefaultView;
    }
    catch (Exception ex)
    {
        MessageBox.Show(ex.Message.ToString());
    }
}

STEP 3 : Create something like return value from file data in a dataset.

C#

public static DataTable GetDataTable(string strFileName)
{
    ADODB.Connection oConn = new ADODB.Connection();
    oConn.Open("Provider=Microsoft.Jet.OleDb.4.0; Data Source = " + System.IO.Path.GetDirectoryName(strFileName) + "; Extended Properties = \"Text;HDR=YES;FMT=Delimited\";", "", "", 0);
    string strQuery = "SELECT * FROM [" + System.IO.Path.GetFileName(strFileName) + "]";
    ADODB.Recordset rs = new ADODB.Recordset();
    System.Data.OleDb.OleDbDataAdapter adapter = new System.Data.OleDb.OleDbDataAdapter();
    DataTable dt = new DataTable();
    rs.Open(strQuery, "Provider=Microsoft.Jet.OleDb.4.0; Data Source = " + System.IO.Path.GetDirectoryName(strFileName) + "; Extended Properties = \"Text;HDR=YES;FMT=Delimited\";",
        ADODB.CursorTypeEnum.adOpenForwardOnly, ADODB.LockTypeEnum.adLockReadOnly, 1);
    adapter.Fill(dt, rs);
    return dt;
}

note : If you have any error please try to set target platform to X86 of your application