[Solved] C# Help : Data Mining

Question

3.80/5 (4 votes)

See more:

I have below code with me .

C#

private void button2_Click(object sender, EventArgs e)
      {
         //This code is for validating the csv file and filling the rows in the grid.
          string Path;
          Path = lblfilepath.Text;
          dataGridView1.DataSource = ReadCSV(Path);
          //Please help me here
      }
      private DataTable ReadCSV(string Filename)
      {
          string MyPath = System.IO.Path.GetDirectoryName(Filename);
          string ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + MyPath + ";Extended Properties='text;HDR=Yes;FMT=Delimited'";
          String todaysdate;
          todaysdate = DateTime.Today.ToString() ;
          string CmdText = "select * from " + System.IO.Path.GetFileName(Filename);
          OleDbConnection Con = new OleDbConnection(ConnectionString);
          OleDbDataAdapter adptr = new OleDbDataAdapter(CmdText, Con);

          //OleDbCommand Cmd = new OleDbCommand(CmdText + txtFileName.Text, Con);
          DataSet Ds = new DataSet();
          adptr.Fill(Ds);
          return Ds.Tables[0];
      }

On the comment line //Please help me here
I need to loop throught the Datagrid and read values from each column from each rows.

Please suggest me how can I make a combination of
DataCommand
DataReader
DataTable
DataAdaptor

Posted 12-Jan-11 8:20am

RDBurmon

Updated 19-Apr-11 22:07pm

v3

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)

#realJSOP · Accepted Answer · 2011-01-12T08:51:00

Solution 1

dataGridView1.Rows provides a collection of DataRow objects in the gridview. Just iterate that collection.

Posted 12-Jan-11 8:51am

#realJSOP

Comments

RDBurmon 13-Jan-11 13:53pm

Thanks Buddy !!

wizardzz · Accepted Answer · 2011-01-12T10:16:00

Solution 2

John is right, if you need access to specific columns just use the .Cells object within the DataRow. You can access via field name or via the row's Items. For example,

foreach (DataRow x in dataGridView1.Rows)
{
//access data either way:
    x.Field<>();
    x.ItemArray;
}

Posted 12-Jan-11 10:16am

wizardzz

Comments

RDBurmon 13-Jan-11 13:53pm

Thanks Buddy !!