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 dataset ?
18 Answers Infosys, Kuwait University,
What is view state and use of it ?
Derive WSDL?
What are skins?
How do you use viewstate?
How you will manage the state of ASP.NET controls?
0 Answers Sans Pareil IT Services,
What is data binding in asp net?
How do you handle session management in ASP.NET and how do you implement them. How do you handle in case of SQLServer mode ?
Describe a Windows Service and its lifecycle ?
What is server side routing?
I am using SQLServer 2005. I have one table called Drivers. Every day thousands of records will be added in this table. I have to show all these records in my GridView with out applying ajax timer beacause we don't know the time limit when the new record come to the table. Sometimes it will add for 10 seconds some times 20 seconds. There by Please try without using timer or any other soultion apply for the table in sqlserver. But, i want to see all records immediately when new record comes in table. How? Thanks in advance... Ramesh
what is the difference between server.Transfer and response.redirect in .net
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)