How to fill Dataset with multiple tables?

by

Filling a DataSet with multiple tables can be done by sending multiple requests to the database, or in a faster way: Multiple SELECT statements can be sent to the database server in a single request. The problem here is that the tables generated from the queries have automatic names Table and Table1. However, the generated table names can be mapped to names that should be used in the DataSet.

SqlDataAdapter adapter = new SqlDataAdapter(
      "SELECT * FROM Customers; SELECT * FROM Orders", connection);
adapter.TableMappings.Add("Table", "Customer");
adapter.TableMappings.Add("Table1", "Order");

adapter.Fill(ds);

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. Direct method from SQL command text to DataSet
  8. Why is a SQL float different from a C# float
  9. ExecuteNonQuery returning -1 when using sql COUNT despite the query string
  10. How do I translate a List into a SqlParameter for a Sql In statement? [duplicate]
  11. Add WHERE clauses to SQL dynamically / programmatically
  12. Check if a SQL table exists
  13. Enabling Foreign key constraints in SQLite
  14. How do I extract data from a DataTable?
  15. Reading a date using DataReader
  16. How to give ADO.NET Parameters
  17. Do we have transactions in MS-Access?
  18. How can I easily convert DataReader to List? [duplicate]
  19. Entering keys manually with Entity Framework
  20. How I can filter a Datatable?
  21. Getting return value from stored procedure in C#
  22. C# guid and SQL uniqueidentifier
  23. Local sequence cannot be used in LINQ to SQL implementation of query operators except the Contains() operator
  24. Entity Framework. Delete all rows in table
  25. Multi threading C# application with SQL Server database calls
  26. Use linq to generate direct update without select
  27. Oracle Parameters with IN statement?
  28. Filtering DataSet
  29. how to recognize similar words with difference in spelling
  30. How to use String property as primary key in Entity Framework

Leave a Comment