i dont know if this is an easy one to pin down. I am doing a datagrid update, and although i&#039;m not getting any error, its not actually updating... so, i&#039;m sure where to start debugging it.<BR><BR>//sub_update code<BR><BR>Sub dgrd_UpdateCommand( s As Object, e As DataGridCommandEventArgs )<BR> <BR> Dim intID As Integer<BR> Dim txtProperty As TextBox<BR> Dim txtDescription As TextBox<BR> Dim strProperty As String<BR> Dim strDescription As String<BR> Dim conn As OleDbConnection<BR> <BR> intID = dgrd.DataKeys( e.Item.ItemIndex )<BR> txtProperty = e.Item.Cells( 1 ).Controls( 0 )<BR> txtDescription = e.Item.Cells( 2 ).Controls( 0 )<BR> strProperty = txtProperty.text<BR> strDescription = txtDescription.text<BR> <BR> Dim strSQL as String = _<BR> "UPDATE featured_properties SET property = @property, " & _<BR> "description = @description " & _<BR> "WHERE user_id = @ID"<BR><BR> conn = New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0; Data Source=c:websites
laink emphomeshomes.mdb")<BR> <BR> Dim cmd as OleDbCommand = new OleDbCommand(strSQL, conn)<BR> <BR><BR> &#039; Add Parameters to the SQL query<BR> cmd.Parameters.Add( "@property", strProperty )<BR> cmd.Parameters.Add( "@description", strDescription )<BR> cmd.Parameters.Add( "@ID", intID )<BR> <BR> conn.Open()<BR><BR> cmd.ExecuteNonQuery() <BR> <BR> conn.Close() &#039;Close the connection<BR><BR> dgrd.EditItemIndex = -1<BR><BR> BindDataGrid<BR>End Sub<BR><BR>&#060;/script&#062;