private static DataTable _GetDataTableByQuery(string connectionString)
{
DataTable dt;
using (DataBroker db = new DataBroker(connectionString))
{
dt = db.GetDataTable("Select * from [dbo].[things]");
}
return(dt);
}
private static DataTable _GetDataTableBySP(string connectionString)
{
DataTable dt;
using (DataBroker db = new DataBroker(connectionString))
{
List <SqlParameter> sqlParams = new List <SqlParameter>();
sqlParams.Add(new SqlParameter {
ParameterName = "@thingId", Value = "1"
});
dt = db.GetDataTable("[dbo].[usp_GetThings]", sqlParams, CommandType.StoredProcedure);
}
return(dt);
}
