How to retrieve data row by row from a DataTable? Thanks In advance PriyaPP

How to retrieve data row by row from a DataTable?
Thanks In advance
PriyaPP

Question Posted / priyapp

3 Answers
11330 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

How to retrieve data row by row from a DataTable? Thanks In advance PriyaPP..

Answer / guest

foreach(Datarow dr in table.rows)
{
string str = dr[0].ToString();
string str1 = dr["columnName"].ToString();

}

Is This Answer Correct ?

11 Yes

3 No

How to retrieve data row by row from a DataTable? Thanks In advance PriyaPP..

Answer / suyash deep

best way to retrieve data is-
//dtTable is Data table
//dtrow id Data Row object

string str;
foreach(DataRow dtrow in dtTable.rows)
{

str= dtrow ["emp_Name"].Tostring();
//emp_Name is the column name

// now use str variable as you want to manipulate.
}

Is This Answer Correct ?

6 Yes

0 No

How to retrieve data row by row from a DataTable? Thanks In advance PriyaPP..

Answer / digvijay

In C#

foreach(DataRow dr in dt.rows) //dt is Data table
{

string ABC= dr["Coloumn_Name"].Tostring;

}

Is This Answer Correct ?

3 Yes

2 No

Post New Answer

More ASP.NET Interview Questions

What are the various authentication mechanisms in ASP.NET ?