gridview edit/delete

In gridview the edit and delete links appear where they belong and on edit the proper expanded edit bar appears allowing me to make changes, but when I click update it closes the edit bar and returns me to my original position without posting the changes.

The same thing happens when I attempt to delete a record.

The database is a single table and I assume the connection string is OK as evidenced by the fact the data is displayed correctly. Edit and delete were selected from the drop-down options menu on the gridview as opposed the inside the properties box.

To really drive me off the deep end, if I create a new site and data base following all the same procedures, I have a 50/50 chance that it will work properly, and I promise I haven't been drinking...yet.

Can anyone shed any light on what's happening here? It feels like I'm missing a step somewhere, but can't figure out where.

Many thanks!

What application are you using to edit your data? What are you doing to view your data in a grid?

In SQL Server 2005 Management Studio, you can right click on the table in Object Explorer and then select "Open Table" in the context menu to bring up an editable grid. You should be able to modify your data directly in the grid.

Hope this helps,
Steve

|||You might need to check the privileges for the account using this way, as it is better to edit or delete the table rows using Queyr editior with TSQL statements.|||

Hi,

I am facing a problem with a Editable grid view.

We have overridden the create row method in gridview to make it multi row editble by setting the rowstate property to edit on the selected row indexes.

We are having dropdowns in edit mode. Till it goes to edit mode it works fine but the after that when click on any button .it displays the "Failed to load view state Error" The controls used to load view state does not match.....

this error only happenes when we use a drop down and dynamically add the dropdown values when on row_created event of datagrid.

Any help would be appriciated.

Regards,

Alok