How to retrieve data row by row from a DataTable?
Thanks In advance
PriyaPP
Answers were Sorted based on User's Feedback
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 |
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 |
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 |
What is state management react?
How do I create a web form?
What is the difference between custom controls and user controls?
can we transfer data from one page to another page using viewstate if so how?if not y?
Explain the difference between asp.net mvc and asp.net webforms? : asp.net mvc
Explain the overview of asp.net?
When web.config is called ?
What are the disadvantages of viewstate/what are the benefits
Which data types are supported by the RangeValidator control?
What is mvc structure? given example? How to show gridview control from business components and using class object arrays?
what is cross page posting
How do I send e-mail from an ASP.NET application ?
Visual Basic (800)
C Sharp (3816)
ASP.NET (3180)
VB.NET (461)
COM+ (79)
ADO.NET (717)
IIS (369)
MTS (11)
Crystal Reports (81)
BizTalk (89)
Dot Net (2435)
Exchange Server (362)
SharePoint (720)
WCF (340)
MS Office Microsoft (6963)
LINQ Language-Integrated Query (317)
WPF (371)
TypeScript (144)
Microsoft Related AllOther (311)