Get cell value from DataTable in C #

Question

Here is a DataTable dt in which there is a lot of data.

I want to get a specific Cell Value from a DataTable, say Cell [i, j] . Where, i → Rows and j → Columns. I will forloops over the value of i, j with two forloops .

But I can’t understand how I can call a cell my index.

Here is the code:

 for (i = 0; i <= dt.Rows.Count - 1; i++) { for (j = 0; j <= dt.Columns.Count - 1; j++) { var cell = dt.Rows[i][j]; xlWorkSheet.Cells[i + 1, j + 1] = cell; } } 

Answer 1

DataRow also has an indexer :

 Object cellValue = dt.Rows[i][j]; 

But I would prefer the strongly typed Field extension method, which also supports nullable types :

 int number = dt.Rows[i].Field<int>(j); 

or even more readable and less error prone column name:

 double otherNumber = dt.Rows[i].Field<double>("DoubleColumn"); 

Answer 2

You probably need to reference it with Rows , not the cell:

 var cellValue = dt.Rows[i][j]; 

Answer 3

You can iterate over a DataTable as follows:

 private void button1_Click(object sender, EventArgs e) { for(int i = 0; i< dt.Rows.Count;i++) for (int j = 0; j <dt.Columns.Count ; j++) { object o = dt.Rows[i].ItemArray[j]; //if you want to get the string //string s = o = dt.Rows[i].ItemArray[j].ToString(); } } 

Depending on the type of data in the DataTable you can drop the object to whatever you want.

Answer 4

You can also call the indexer directly on the datatable variable:

 var cellValue = dt[i].ColumnName 

Answer 5

you cannot, but, Alternatively, you can use the table with which you populated the dataGridView.

Answer 6

If I understand your question correctly, do you want to display one specific cell of your populated datatable? This is what I used to display this cell in my DataGrid.

 var s = dataGridView2.Rows[i].Cells[j].Value; txt_Country.Text = s.ToString(); 

Hope this helps