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); }