Filling a DataTable from the DataRow array using CopyToDataTable() : DataRow « ADO.Net « C# / CSharp Tutorial

Home C# / CSharp Tutorial 1. Language Basics 2. Data Type 3. Operator 4. Statement 5. String 6. struct 7. Class 8. Operator Overload 9. delegate 10. Attribute 11. Data Structure 12. Assembly 13. Date Time 14. Development 15. File Directory Stream 16. Preprocessing Directives 17. Regular Expression 18. Generic 19. Reflection 20. Thread 21. I18N Internationalization 22. LINQ 23. GUI Windows Forms 24. Windows Presentation Foundation 25. Windows Communication Foundation 26. Workflow 27. 2D 28. Design Patterns 29. Windows 30. XML 31. XML LINQ 32. ADO.Net 33. Network 34. Directory Services 35. Security 36. unsafe C# / C Sharp C# / C Sharp by API C# / CSharp Open Source

C# / CSharp Tutorial » ADO.Net » DataRow   32.33.8.Filling a DataTable from the DataRow array using CopyToDataTable() using System; using System.Data; using System.Data.SqlClient;     class Program     {         static void Main(string[] args)         {             string sqlConnectString = "Data Source=(local);Integrated security=SSPI;Initial Catalog=AdventureWorks;";             string sqlSelect = "SELECT ContactID, FirstName, LastName FROM Person.Contact";             SqlDataAdapter da = new SqlDataAdapter(sqlSelect, sqlConnectString);                          DataTable dt1 = new DataTable();             da.Fill(dt1);             DataRow[] dra = new DataRow[dt1.Rows.Count];             dt1.Rows.CopyTo(dra, 0);             for (int i = 0; i < dra.Length; i++){                 Console.WriteLine(                     "ContactID = {0}\tFirstName = {1}\tLastName = {2}",                     dra[i].Field<int>("ContactID"), dra[i].Field<string>("FirstName"),                     dra[i].Field<string>("LastName"));             }             DataTable dt2 = dra.CopyToDataTable();             foreach (DataRow row in dt2.Rows)             {                 Console.WriteLine(                     "ContactID = {0}\tFirstName = {1}\tLastName = {2}",                     row["ContactID"], row["FirstName"], row["LastName"]);             }         }     } 32.33.DataRow 32.33.1. DataRow Update 32.33.2. Accessing Data Values in a DataRow Array by column name 32.33.3. Accessing Data Values in a DataRow Array by column name and return default value 32.33.4. Accessing Data Values in a DataRow Array by index 32.33.5. Accessing Data Values in a DataRow Array in a generic way by index 32.33.6. Accessing Data Values in a DataRow Array in a generic way by name 32.33.7. DataView and DataRowView 32.33.8. Filling a DataTable from the DataRow array using CopyToDataTable() 32.33.9. Filling a DataTable from the DataRow array using CopyToDataTable(DataTable, LoadOption) 32.33.10. Using foreach statement with DataRow in DataTable 32.33.11. For loop over DataRow array 32.33.12. Get first index in a row 32.33.13. DataRowState manipulation 32.33.14. Create and fill the DataRow array 32.33.15. Get column value in a row 32.33.16. Get value from a row with default value