// gets the studio name using the studio id
public static string FetchProductionCompany(int id)
{
string sql = SqlProcedures.FetchProductionCompany(id);
DataTable temp = Call(sql);
return(temp.Rows[0][0].ToString());
}