public void prueba1() { //SELECT COLUMN_NAME FROM INFORMATION_SCHEMA.COLUMNS where TABLE_NAME='usuario' String inicio = ""; String final = ""; using (SqlConnection con = conexion.obtenerConexion()) { SqlCommand comando = new SqlCommand(string.Format("SELECT distinct TABLE_NAME,COLUMN_NAME, DATA_TYPE FROM INFORMATION_SCHEMA.COLUMNS"), con); List <refactory> lista = new List <refactory>(); SqlDataReader reader = comando.ExecuteReader(); int i = 0; while (reader.Read()) { inicio = (String)reader.GetValue(0); refactory refa = new refactory((string)reader.GetValue(0), (string)reader.GetValue(1), (string)reader.GetValue(2)); if (inicio.Equals(final) || i == 0) { lista.Add(refa); i++; } else { createFile(final, lista); lista.RemoveRange(0, lista.Count()); lista.Add(refa); i = 0; } final = (String)reader.GetValue(0); } if (i != 0) { createFile(final, lista); lista.RemoveRange(0, lista.Count()); } con.Close(); } }
public void prueba1() { //SELECT COLUMN_NAME FROM INFORMATION_SCHEMA.COLUMNS where TABLE_NAME='usuario' String inicio = ""; String final = ""; using (SqlConnection con = conexion.obtenerConexion()) { SqlCommand comando = new SqlCommand(string.Format("SELECT distinct TABLE_NAME,COLUMN_NAME, DATA_TYPE FROM INFORMATION_SCHEMA.COLUMNS"), con); List<refactory> lista = new List<refactory>(); SqlDataReader reader = comando.ExecuteReader(); int i = 0; while (reader.Read()) { inicio = (String)reader.GetValue(0); refactory refa = new refactory((string)reader.GetValue(0), (string)reader.GetValue(1),(string) reader.GetValue(2)); if (inicio.Equals(final) || i==0) { lista.Add(refa); i++; } else { createFile(final , lista); lista.RemoveRange(0, lista.Count()); lista.Add(refa); i = 0; } final =(String)reader.GetValue(0); } if (i != 0) { createFile(final, lista); lista.RemoveRange(0, lista.Count()); } con.Close(); } }