I am trying to use VisualWebDeveloper-2005-Express to modify / expand the Commerce Starter Kit.  So far the Kit site is working fine and I have managed to add a few new (my own) pages to the site and I have connected to another database for some of the data.  To access the other database I added a SqlDataSource to the page and configured it to connect to the new sql server data source.  I can NOT use the Advanced SQL Generation Options from the Configure Select Statement screen...(everything is set to disabled? cannot click on anything)...
I copied the code from the Commerce Starter Kit to create Insert, Delete and Update commands, parameters, etc. into my new SqlDataSource...  The Select works fine to populate the Grid View and the Delete command works fine...
The Insert and Update commands - do NOT work at all...

Could this have anything to do with the Advanced SQL Generation Options NOT being available?

Why are the Advanced SQL Generation Options NOT available?

Any ideas why my new SqlDataSource Insert and Update commands don't work?

Thanks,
Paul

I am soooo embarrassed, now that I have looked again in the FAQ – I had selected the Key but it was not marked Primary.  Works – just like it should.

Sorry for the premature post.

Paul  :(

hi

yes i also face the Same PRoblem

Hi  you have to Re Design The Table make Sure You have Set Primary On your Table and any Nullable Columns are available. and Your Primary Key Column Should be there

 

Happy Programming

The key is the Primary Key !

Check your database and make sure that your table has a Primary Key! It will work!

Sudi