Updating individual fields from a row in LINQ

[Mhogshaw]

Hi,

I am trying to update 3 individual fields from a row in my database using LINQ. I have to enter a student id when the page runs then this matches their record in the database and populates the gridview with the 3 fields that i want to edit. Is their any way to do this? So far i have this,

Protected Sub SubBtn_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles SubBtn.Click
 
Dim number = txtStudentID.Text
 
Dim db As New OrionDataClassesDataContext()
 
 
Dim match = From u In db.Users
Where u.User_Number = number
Select u.Contact_number, u.Home_address, u.Term_address
 
GridView1.DataSource = match
GridView1.DataBind()
 
End Sub

Any help much appreciated.
Thanks,
Michael

[vijay6]

Hey Mhogshaw, Create a new button. Once if that button was clicked then connect to your database and update fields like as follows,

Private Sub Save_Click(sender As Object, e As EventArgs)
    Try
        Dim con As New SqlConnection("Your database connection string")
 
        For i As Integer = 0 To dataGridView1.Rows.Count - 1
 
            Dim cmd As New SqlCommand("UPDATE Users SET 
            Contact_number = '" + dataGridView1.Rows(i).Cells(0).Value.ToString() + "', 
            Home_address = '" + dataGridView1.Rows(i).Cells(1).Value.ToString() + "', 
            Term_address = '" + dataGridView1.Rows(i).Cells(2).Value.ToString() + "' 
            WHERE User_Number = '" + txtStudentID.Text + "'", con)
 
            con.Open()
            cmd.ExecuteNonQuery()
        Next
 
        MsgBox("Updated")
    Catch ex As Exception
        MsgBox(ex.ToString())
    Finally
        con.Close()
    End Try
End Sub