Abreu Solutions - Develope data

Introdução - app_Data

Descubra o App Abreu Solutions, diponibiza diverças ferramentas em formato framework v4.7.2.

getDataSet

BRA>> (método que retorna um DataSet, com restrição e validação contra ataques, permite apenas métodos “Select, Insert, Update, Delete e EXEC”);
USA>> (method that returns a DataSet, with restriction and validation against attacks, only allows “Select, Insert, Update, Delete and EXEC” methods);

ConfigurationManager.AppSettings["ConnString"];

Requisição

File ==>> Web.Config;

<add key="ConnString" value="############################; Integrated Security=True; Connect Timeout=600000;" />

string SQL = "SELECT * FROM user ORDER BY name ASC";

DS = getDataSet(SQL);

Retorno

DataSet DS = new DataSet();

DS.Tables["dsData"].Rows.Count;

getDataSet

BRA>> (método que retorna um DataSet, com restrição e validação contra ataques, permite apenas métodos “Select, Insert, Update, Delete e EXEC”);
USA>> (method that returns a DataSet, with restriction and validation against attacks, only allows “Select, Insert, Update, Delete and EXEC” methods);

Requisição

File ==>> Web.Config;

<add key="ConnString" value="############################; Integrated Security=True; Connect Timeout=600000;" />

string SQL = "SELECT * FROM user ORDER BY name ASC";

int CurrentPage = 1;

int QtyItems = 50; (QtyRows/Linhas)

DS = getDataSet(SQL, CurrentPage, QtyItems);

Retorno

DataSet DS = new DataSet();

DS.Tables["dsData"].Rows.Count;

int Total_Pages = Convert.ToInt(DS.Tables["dsPage"].Rows[0]["Pages"]);

int Total_Items = Convert.ToInt(DS.Tables["dsPage"].Rows[0]["Items"]);