Hiding columns when binding datasource to a gridview

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().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

Re: Hiding columns when binding datasource to a gridview

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


"taa" wrote in message
news:1d21ea61-41f4-42fa-ae81-1d1ed27b50f0@24g2000hsh.googleg roups.com...
> 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().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