/// <summary>
/// Loads the results of a SQL query into a DataTable object.
/// Uses the default connection string "Halide".
/// </summary>
/// <example>
/// <code>
/// using Mezzocode.Halide3;
/// ...
/// DataTable dt = h3Sql.ReadTable("SELECT TOP 5 FROM tablename;");
/// </code>
/// </example>
/// <param name="Statement">SQL statement to execute.</param>
/// <returns>DataTable object.</returns>
public static DataTable ReadTable(string Statement)
{
DataTable dt = new DataTable();
using (h3Reader reader = new h3Reader(Statement))
{
dt = reader.ReadTable();
}
return (dt);
}
/// <summary>
/// Loads the results of a SQL query into a DataTable object.
/// </summary>
/// <example>
/// <code>
/// using Mezzocode.Halide3;
/// ...
/// DataTable dt = h3Sql.ReadTable("SELECT TOP 5 FROM tablename;", "SqlServer01");
/// </code>
/// </example>
/// <param name="Statement">SQL statement to execute.</param>
/// <param name="ConnectionStringName">Name of a connection string in the Web.config file.</param>
/// <returns>DataTable object.</returns>
public static DataTable ReadTable(string Statement, string ConnectionStringName)
{
DataTable dt = new DataTable();
using (h3Reader reader = new h3Reader(Statement, ConnectionStringName))
{
dt = reader.ReadTable();
}
return (dt);
}
