Advanced SQL Generation Options are grayed out

No matter how I get to it, I can not figure out how to check the "Generate INSERT, UPDATE, and DELETE statements" through Data Source. How do I set it to allow changes to the db from the page?

Thanks,

Nate

Re: Advanced SQL Generation Options are grayed out

you can find here an example to manupulation with datasource

with gridview :http://forums.asp.net/t/1631974.aspx

Re: Advanced SQL Generation Options are grayed out

Well, what happens is this...

I select my GridView, then click on Configure Data Source. I already have a connection so I click Next. On the "Configure the Select Statement" window with "Specify columns form a table or view" selected, there is an "Advanced..." button. When I click on it, I can see the "Advanced SQL Generation Options" window pop up, but can't checkmark anything.

Re: Advanced SQL Generation Options are grayed out

Ok, I figured it out. I needed my tables to have Primary Keys.

Re: Advanced SQL Generation Options are grayed out

Does anyone know how to get the Advanced Selections Options working with a view or with a SQL Statement which is similar to a view.

Having a table without it's related data isn't much use at the moment and I need to find a way to insert, update and delete in a table with useful (related) data or a view...