I have a simple application that has a form with a datagrid, text, and command button. The user can type in a SQL statement in the text box and get the results in the grid, then the user can update data in the table.
The problem I ran into was if there are more than 1 record displayed in the grid everything works ok. The user can update the data like an excel spread.
But if there is only one record in the grid, and the user tries to update it, it acts like it works, but it is not really updating it. If the user update the 1 record, then turns around and queries it again to see if the update worked, it never works.
Does some know why this would happen? It this a datagrid control bug? Or is this a SQL server bug/ weirdness?