I tweeked all the properties fields of the data-bound control and finally discovered the problem property field.
In my opinion it simply is not all that obvious at all and the MSDN help isn't that very helpful. Now it is all working ok. If anyone is interested in the solution, pl post here. Thanks TFE http://totallyfreeenergy.zxq.net --- In [email protected], "Totally Freeenergy" <totallyfreeene...@...> wrote: > > 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 >
