Hiding columns when binding datasource to a gridview

[taa]

protected void LoadExercises(object sender, EventArgs e)
{
// Navn, (Beskrivelse), Type, Exid, Target
var exercises = from ex in context.Exercises
select new {exerciseId = ex.ExerciseId,
exerciseName = ex.Name, exerciseType = ex.ExerciseType.Name,
exerciseTarget = ex.Targets.First<Target>().Muscle.Name };
ExercisesGridView.DataSource = exercises;
ExercisesGridView.DataBind();

}

I'm using the code above to fill a gridview. but how do I prevent it
from showing exerciseId while still being able to use it?
Furthere more how do I enable selection?

best regards,
taa

 

[Eliyahu Goldin]

Set AutoGenerateColumns=false, specify only the columns you want to show and
assign ExerciseId to the DataKeyNames property.

For the selection part, add a ColumnField with ShowSelectButton.

--
Eliyahu Goldin,
Software Developer
Microsoft MVP [ASP.NET]
http://msmvps.com/blogs/egoldin
http://usableasp.net