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