How do I create a DataTable, then add rows to it?

by

Here’s the code:

DataTable dt = new DataTable(); 
dt.Clear();
dt.Columns.Add("Name");
dt.Columns.Add("Marks");
DataRow _ravi = dt.NewRow();
_ravi["Name"] = "ravi";
_ravi["Marks"] = "500";
dt.Rows.Add(_ravi);

To see the structure, or rather I’d rephrase it as schema, you can export it to an XML file by doing the following.

To export only the schema/structure, do:

dt.WriteXMLSchema("dtSchemaOrStructure.xml");

Additionally, you can also export your data:

dt.WriteXML("dtDataxml");

More Related Contents:

  1. How to use Select method of DataTable
  2. How to create a DataTable in C# and how to add rows?
  3. Creating a SQL Server table from a C# datatable
  4. How to fill a datatable with List [duplicate]
  5. Thread safety for DataTable
  6. DataTable equivalent in Java [duplicate]
  7. How do you Sort a DataTable given column and direction?
  8. Convert generic List/Enumerable to DataTable?
  9. Convert JSON to DataTable
  10. MetadataException: Unable to load the specified metadata resource
  11. Get the generated SQL statement from a SqlCommand object?
  12. Inner join of DataTables in C#
  13. How To Change DataType of a DataColumn in a DataTable?
  14. Get connection string from App.config
  15. How to select min and max values of a column in a datatable?
  16. How to compare 2 dataTables
  17. Handling ExecuteScalar() when no results are returned
  18. Is SqlCommand.Dispose() required if associated SqlConnection will be disposed?
  19. How to pass a table-value parameter
  20. Best way to check if a Data Table has a null value in it
  21. How to Read text file to DataTable [closed]
  22. Mapping columns in a DataTable to a SQL table with SqlBulkCopy
  23. How can I convert a DataTable into a Dynamic object?
  24. How to in-code supply the password to a connection string in an ADO.Net Entity Data Model
  25. .net connection pooling
  26. ADO.Net Entity Framework An entity object cannot be referenced by multiple instances of IEntityChangeTracker
  27. How can I convert a DataTable to an XML file in C#?
  28. Passing array to a SQL Server Stored Procedure
  29. Is it possible to format a date column of a datatable?
  30. Why does var evaluate to System.Object in “foreach (var row in table.Rows)”?

Leave a Comment