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?
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.
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...
nau1977
Member
135 Points
49 Posts
Advanced SQL Generation Options are grayed out
Jun 29, 2011 04:37 PM|LINK
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
princeG
Star
9612 Points
1602 Posts
Re: Advanced SQL Generation Options are grayed out
Jun 29, 2011 04:45 PM|LINK
you can find here an example to manupulation with datasource
with gridview :http://forums.asp.net/t/1631974.aspx
nau1977
Member
135 Points
49 Posts
Re: Advanced SQL Generation Options are grayed out
Jun 29, 2011 05:14 PM|LINK
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.
nau1977
Member
135 Points
49 Posts
Re: Advanced SQL Generation Options are grayed out
Jun 30, 2011 06:59 PM|LINK
Ok, I figured it out. I needed my tables to have Primary Keys.
meridius10
Member
22 Points
29 Posts
Re: Advanced SQL Generation Options are grayed out
May 07, 2012 10:25 AM|LINK
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...