Read data from SQL Server table into .Net DataTable object using SqlDataAdapter

Following code snippets reads data from a SQL Server table into .Net DataTable object:

using System.Data;

using System.Data.SqlClient;
public DataTable RetrieveRowsWithDataTable()

{

  using ( SqlConnection conn = new SqlConnection("ConnectionString") )

  {

    conn.Open();

    SqlCommand cmd = new SqlCommand("SELECT * FROM PRODUCTS", conn);

    cmd.CommandType = CommandType.Text;

    SqlDataAdapter adapter = new SqlDataAdapter(cmd);

    DataTable dataTable = new DataTable("Products");

    adapter.Fill(dataTable);

    return dataTable;

  }

}