HOw to update datagrid?

You need to use the DataAdapter.

This is how i do my datagrid... i only do it in the vb format.... but not in html cos if i do it in html it is static not dynamic... Dim type, searchid As String Dim strSQL As String Dim cmd As New SqlClient.SqlCommand Dim dbRead type = ddlSearch.SelectedValue searchid = txtSearch.Text & "%" If type = "MatrixID" Then strSQL = "SELECT MatrixID, [User], FirstName, LastName, Balance FROM tblStudent WHERE MatrixID LIKE '" & searchid & "'" ElseIf type = "User" Then strSQL = "SELECT MatrixID, [User], FirstName, LastName, Balance FROM tblStudent WHERE [User] LIKE '" & searchid & "'" ElseIf type = "LastName" Then strSQL = "SELECT MatrixID, [User], FirstName, LastName, Balance FROM tblStudent WHERE LastName LIKE '" & searchid & "'" ElseIf type = "Balance" Then strSQL = "SELECT MatrixID, [User], FirstName, LastName, Balance FROM tblStudent WHERE Balance LIKE '" & searchid & "'" End If If sqlConn.State = ConnectionState.Open Then sqlConn.Close() End If sqlConn.Open() cmd = New SqlClient.SqlCommand(strSQL, sqlConn) dbRead = cmd.ExecuteReader() grdStudent.DataSource = dbRead grdStudent.DataBind() If grdStudent.Items.Count <= 0 Then grdStudent.Visible = False lblWarning.Text = "No Record Found!" lblWarning.Visible = True Else grdStudent.Visible = True lblWarning.Text = "Total of " & grdStudent.Items.Count & " records found" End If dbRead.close() sqlConn.Close()

Readonly??how do you bind the data to the datagrid?