How to convert DataSet to DataTable

I am retrieving data from a SQL table so I can display the result on the page as a HTML table. Later I need to be able to save that table as a CSV file.

So far I have figured out how to retrieve the data and fill them in a dataset for display purpose (which is working perfectly)...

        string selectQuery = "SELECT Name, ProductNumber, ListPrice FROM Poduction.Product";

        // Establish the connection to the SQL database 
        SqlConnection conn = ConnectionManager.GetConnection();

        // Connect to the SQL database using the above query to get all the data from table.
        SqlDataAdapter myCommand = new SqlDataAdapter(selectQuery, conn);

        // Create and fill a DataSet.
        DataSet ds = new DataSet();

and how to save them in a CSV file with the help of following code from:

    private void exportDataTableToCsv(DataTable formattedDataTable, string filename)
       DataTable toExcel = formattedDataTable.Copy();
       HttpContext context = HttpContext.Current;

       foreach (DataColumn column in toExcel.Columns)
          context.Response.Write(column.ColumnName + ",");

       foreach (DataRow row in toExcel.Rows)
          for (int i = 0; i < toExcel.Columns.Count; i++)
             context.Response.Write(row.ToString().Replace(",", string.Empty) + ",");


       context.Response.ContentType = "text/csv";
       context.Response.AppendHeader("Content-Disposition", "attachment; filename=" + filename + ".csv");

Now my problem is how do I convert this DataSet to DataTable? I have tried the way described here with NO luck:

Can anyone help me?


A DataSet already contains DataTables. You can just use:

DataTable firstTable = dataSet.Tables[0];

or by name:

DataTable customerTable = dataSet.Tables["Customer"];

Note that you should have using statements for your SQL code, to ensure the connection is disposed properly:

using (SqlConnection conn = ...)
    // Code here...

DataSet is collection of DataTables.... you can get the datatable from DataSet as below.

//here ds is dataset
DatTable dt = ds.Table[0]; /// table of dataset

Here is my solution:

DataTable datatable = (DataTable)dataset.datatablename;

Need Your Help

Reading from CSVs in Python repeatedly?

python csv

I'm trying to check the value of extracted data against a csv I already have. It will only loop through the rows of the CSV once, I can only check one value of feed.items(). Is there a value I need...

How to determine if a date falls on the weekend?

excel vba excel-vba

Given a date as input, how can I determine whether the day falls on a weekend?