public ResultSetX(SqlDataReader reader)
{
if (reader != null && reader.HasRows)
{
// Se crean las cabeceras.
headers = new Dictionary <string, int>();
for (int i = 0; i < reader.FieldCount; i++)
{
headers.Add(reader.GetName(i), i);
}
// Se guardan los datos en una matriz.
table = new List <List <object> >();
while (reader.Read())
{
List <object> list = new List <object>();
for (int ordinal = 0; ordinal < reader.FieldCount; ordinal++)
{
list.Add(ResultSetX.getValueFieldX(reader, ordinal));
}
table.Add(list);
}
ReStart();
}
}
public ResultSetX getTableX(string sql)
{
ResultSetX set;
try
{
connecttodb();
SqlCommand cmd = new SqlCommand(sql, connect);
SqlDataReader reader = cmd.ExecuteReader();
set = new ResultSetX(reader);
}
catch (Exception ex)
{
set = new ResultSetX();
Debug.WriteLine(ex.ToString());
}
finally
{
closeconnection();
}
return(set);
}
