Edit/Delete/Insert SQL server...

[hughejars]

Hi again

I wrote a web site on my lappie running XP, and developed a web site using a SQL database which I could up date from a web browser. I used Gridview to show the database and enabled Paging and Select, so I could view the details in a FormsView where I could edit the details, or delete or Add new items.
It worked great and did everything flawlessly.
Happy my solution worked, I went over to my server which is running Windows 2003 small business server and repeated the project, (not just copying the web site over).
But whenever I try and edit or delete in the FormView the database dosn't update the details, but seems to add new items ok. It also won't updtae if I edit or delete in GridView or DetailsView either.
Does anyone know why this might be?

Cheers
Phil

Working towards my MCSE/A and CompTIA. Any help greatly appreciated.

 

[ca8msm]

Have you checked sql profiler to see what is being executed against the database?


-------------------------------------------------------

Mark,
[URL unfurl="true"]http://aspnetlibrary.com[/url]
[URL unfurl="true"]http://mdssolutions.co.uk[/url] - Delivering professional ASP.NET solutions
[URL unfurl="true"]http://weblogs.asp.net/marksmith[/url]

 

[jbenson001]

You'll be best off debugging your application to see what is happening, and also using SQL Profiler as Mark has stated.