// Get all studios that currently exist. This is used when a form is opened to populate the dropdown boxes.
public static List <string> RetrieveStudios()
{
DataTable temp = Call(SqlProcedures.RetrieveStudios());
List <string> studios = new List <string>();
for (int i = 0; i < temp.Rows.Count; i++)
{
studios.Add(temp.Rows[i][1].ToString());
}
return(studios);
}