public static int ScoopSqlCommandCount(string sql, SqlParameter[] parameter = null)
{
var dataTable = new System.Data.DataTable();
try
{
dataTable = DataTableProses.GetDataTableSqlDataAdapter(sql, parameter, dataTable);
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
return((int)dataTable.Rows[0][0]);
}
public static List <T> ScoopSqlCommand(string sql, SqlParameter[] parameter = null)
{
var dataTable = new System.Data.DataTable();
try
{
dataTable = DataTableProses.GetDataTableSqlDataAdapter(sql, parameter, dataTable);
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
var anonimT = DataTableConvert.DataTableToList <T>(dataTable);
return(anonimT);
}