How do I extract data from a DataTable?

by

The DataTable has a collection .Rows of DataRow elements.

Each DataRow corresponds to one row in your database, and contains a collection of columns.

In order to access a single value, do something like this:

 foreach(DataRow row in YourDataTable.Rows)
 { 
     string name = row["name"].ToString();
     string description = row["description"].ToString();
     string icoFileName = row["iconFile"].ToString();
     string installScript = row["installScript"].ToString();
 }

More Related Contents:

  1. How can I add user-supplied input to an SQL statement?
  2. How to use DbContext.Database.SqlQuery(sql, params) with stored procedure? EF Code First CTP5
  3. Pass table valued parameter using ADO.NET
  4. Is it necessary to manually close and dispose of SqlDataReader?
  5. How to save image in database using C# [closed]
  6. SqlBulkCopy from a List
  7. How to fill Dataset with multiple tables?
  8. ExecuteNonQuery returning -1 when using sql COUNT despite the query string
  9. How do I translate a List into a SqlParameter for a Sql In statement? [duplicate]
  10. Add WHERE clauses to SQL dynamically / programmatically
  11. Check if a SQL table exists
  12. Enabling Foreign key constraints in SQLite
  13. How to give ADO.NET Parameters
  14. Do we have transactions in MS-Access?
  15. How do parameterized queries help against SQL injection?
  16. How to execute an .SQL script file using c#
  17. Entering keys manually with Entity Framework
  18. Getting return value from stored procedure in C#
  19. How to run multiple SQL commands in a single SQL connection?
  20. C# guid and SQL uniqueidentifier
  21. Local sequence cannot be used in LINQ to SQL implementation of query operators except the Contains() operator
  22. Stop SQL query execution from .net Code
  23. Entity Framework. Delete all rows in table
  24. Multi threading C# application with SQL Server database calls
  25. Use linq to generate direct update without select
  26. What size do you use for varchar(MAX) in your parameter declaration?
  27. Convert SQL to LINQ Query [closed]
  28. Must declare the table variable @table
  29. How to use String property as primary key in Entity Framework
  30. How to get efficient Sql Server deadlock handling in C# with ADO?

Leave a Comment