how to read pariculor row & column data from datatable using c#

Question

0.00/5 (No votes)

See more:

I want read some of data from datatable with for loop condition .in that datatable I want read some particular rows and column data with help of some row no (10 to 15) and (column no 5 to 10)

DataTable tbl = new DataTable();

for(tbl.row=10; tbl.row<=15;tbl.row++)
         {
                 for(tbl.colum=5; tbl.colum<=10;lt;=15;tbl.colum++)
                       {
                          string cell=[tbl.row].[tbl.colum]
                         }
           }

Posted 16-Mar-15 19:13pm

Member 10562086

Add a Solution

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)

Subramanyam Shankar · Accepted Answer · 2015-03-16T19:54:00

Solution 1

C#

//dataTab is the datatable

//reading all the data for all rows and columns.
for (int j = 0; j < dataTab.Rows.Count; j++)
{
    for (int i = 0; i < dataTab.Columns.Count; i++)
    {
        Console.WriteLine(dataTab.Rows[j][i]);
    }
}

//Reading data for rows 10 to 15 and columns 5 to 10
//j is used for rows
for (int j = 9; j < 15; j++)
{
    //i is used for columns
    for (int i = 4; i < 10; i++)
    {
        Console.WriteLine(dataTab.Rows[j][i]);
    }
}

Posted 16-Mar-15 19:54pm

Subramanyam Shankar

Updated 17-Mar-15 22:39pm

v4

Comments

Maciej Los 17-Mar-15 2:57am

j=10 it means start from row no. 11 ;)

Subramanyam Shankar 17-Mar-15 4:53am

Thanks :)

Member 10562086 17-Mar-15 6:27am

thanks for your reply :)

Subramanyam Shankar 17-Mar-15 6:32am

You are welcome :)

Member 10562086 17-Mar-15 6:40am

Sir . I have one excel sheet,the excel sheet data and what ever data from datatable data both are same . i want compare both "datatable" data and excel sheet each cell data .please help on that ,if both data is same then i want display message ,,other wise i have to display message ,,like "data miss match in excel sheet and Datatable data in row no 8 and column 10" like that ,please help me

Subramanyam Shankar 17-Mar-15 6:48am

If my solution provided above is correct.Please mark as accepted.I will surely help you with this one. Will give it tomorrow.

Member 10562086 18-Mar-15 3:21am

I accepted your solution sir.can you please give me a solution for above validate dadatable data and excel sheet data

Subramanyam Shankar 18-Mar-15 4:49am

void CompareData(DataTable dataTab)
{
string filePath = @"F:\Book2.xlsx";

Microsoft.Office.Interop.Excel.Application xlApp = new Microsoft.Office.Interop.Excel.Application();
Microsoft.Office.Interop.Excel.Workbook xlWorkBook;

try
{
xlWorkBook = xlApp.Workbooks.Open(filePath, 0, true, 5, "", "", false, Microsoft.Office.Interop.Excel.XlPlatform.xlWindows, "\t", true, false, 0, true, 0);

Microsoft.Office.Interop.Excel.Worksheet worksheet1 = (Microsoft.Office.Interop.Excel.Worksheet)xlApp.Worksheets["Sheet1"];
//Reading for rows 10 to 15 and columns 5 to 10.
//j is used for rows
//Note:- 1st row in excel will be header values. so starting with +1.
for (int j = 10; j <16 ; j++)
{
//i is used for columns
for (int i = 5; i < 11; i++)
{
//In the datatable the row starts with 0 .so doing a subtraction.
if (dataTab.Rows[j-10][i-5] == Convert.ToString(worksheet1.Cells[j, i].Value2))
{
Console.WriteLine(dataTab.Rows[j][i]);
Console.WriteLine("Data matched");
}
else
{
Console.WriteLine("Data mismatch");
}
}
}
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
finally
{
xlApp.Quit();
}

}