I have developed a client-server application on the Visual Web Developer 2008 edition. The database is on SQL server 2008. It is mostly wizard and control driven. Well I have a form control which displays the records in a table. The control has inbuilt controls for INSERT, DELETE and UPDATE. You have to write up the SQL query for these. INSERT and DELETE are working. UPDATE has no effect on the recordset. The SQL query goes like this....
UPDATE EmployeesTable SET Emp_Name = @Emp_Name, Emp_Title = @Emp_Title WHERE Emp_ID = @Emp_ID There don't seem to be anything the matter with the syntax of the query. Besides INSERT and DELETE Work. I have no idea why UPDATE should not work. Has anyone else encountered a similar trouble with VS 2008 Express edition on Windows XP? Thanx-in-advance. TFE http://totallyfreeenergy.zxq.net
