displaying data from database into a table form

I'm reading data from a table in the database ( Album Name , Artist Name)
these are the functions to retrieve data:
Data Layer function
public DataTable getAlbums(int id) { string query = string.Format("select * from [Albums] "); SqlParameter[] sqlParameters = new SqlParameter[2]; sqlParameters[0] = new SqlParameter("@AlbumName", SqlDbType.VarChar); sqlParameters[1] = new SqlParameter("@AlbumArtist", SqlDbType.VarChar); return conn.executeSelectQuery(query, sqlParameters); }
business layer function:

public ValueObj getAllAlbums(int id) { ValueObj userVO = new ValueObj(); DataTable dataTable = new DataTable();
dataTable = dal.getAlbums(id);
foreach (DataRow dr in dataTable.Rows) { userVO.IDAlbum = Int32.Parse(dr["Id_album"].ToString()); userVO.AlbumName = dr["AlbumName"].ToString(); userVO.AlbumArtis ...