Hey all,

I have a Gridview that is presenting a list of students that attended a course, I have created a template field with a checkbox that if checked by the instructor it means the student has attended the course.

Then I have Submit button at the bottom of the page, what I want is for the instructor to just run down the list check each student that did attend the course, then click the Submit button.

Where I am drawing the blank is how to get each one of those DataKey's which happens to be StudentID into a list if they have been checked so I can then run through my Update statement to make the change in the database.

Hints, tips, pointers or links to some online info or even a suggestion on a better way to do this would all be greatly appreciated.

Thanks,

Hi,

The button on which you want to check the GirdView's check boxes try to write this code

        ArrayList arrList = new ArrayList();
        foreach (GridViewRow dr in GridView1.Rows)
        {
            if (dr.RowType == DataControlRowType.DataRow)
            {
                if (((CheckBox)dr.FindControl("chkStudent")).Checked)
                {
                    arrList.Add(GridView1.DataKeys[dr.RowIndex].ToString());
                }
            }
        }

 For that you have to put a check box in template column and name it like chkStudent. Assign DataKeyNames to the GridView. It will work then.

Hope it will help you out.

Thanks and best regards,

Thanks farazsk11,

I will give it a go and post my results.

Any one care to convert to VB? 

I usually can fake my way through that, but this one I am having problems getting the C# to VB convertion.

Thanks

Here's an online conversion utility http://www.developerfusion.co.uk/utilities/convertcsharptovb.aspx.

Hope that helps.

Aaron

Here is the final code for anyone ever trying to the same thing, it works like a charm thank you to the two people that helped me out with this.

Dim sConnStr As String = "Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\Database.MDF;Integrated Security=True;User Instance=True"

Dim con As New SqlConnection(sConnStr)

For Each dr As GridViewRow In GridView1.Rows

If dr.RowType = DataControlRowType.DataRow Then

If DirectCast(dr.FindControl("chkStudent"), CheckBox).Checked Then

End If

End If

Next

Dim i As Integer

Const SQL As String = "UPDATE Trainee SET Attended = @Attended WHERE (TraineeID = @TraineeID)"

myCommand.Parameters.AddWithValue("@Attended", "Attended")

Next

End Sub

I'm a little confuse but this code actually allow changing value to the GridView from an external control right?

No this allows you to change a value in a gridview, with a check box control within the gridview. In this instance the code allowed me to check many rows in a single gridview then click a process button that change a value of attended from false to true within the database.