public static string GetQuery(MainForm.Table state) { switch (state) { case MainForm.Table.Import: case MainForm.Table.Songs: return(Properties.Resources.allQuery); case MainForm.Table.Albums: return("select * from albums"); case MainForm.Table.Authors: return("select * from authors"); } return(null); }
public static List <string> GetColumnNames(MainForm.Table state) { SqlCommand command = new SqlCommand(GetQuery(state), Connection); // Open the connection in a try/catch block. // Create and execute the DataReader, writing the result // set to the console window. SqlDataReader reader = command.ExecuteReader(); List <string> output = new List <string>(); for (int i = 0; i < reader.FieldCount; i++) { output.Add(reader.GetName(i)); } reader.Close(); return(output); }