The usual reason for this is that you have not included the primary key in
the Select statement so it cannot autonatically generate corresponding
Insert, Update and Delete statements.
You can still do it all yourself though.
"mosscliffe" wrote:
> I created a new table in Visual Web Developer for SQL Server Express
> 2005. I created a 'gridview' by dragging the table onto an empty web
> form in Visual Developer Express.
>
> Clicked on the smart tag 'configure data source'. When I click Advanced
> should see
> the Generate Insert, Update and Delete statements check box but it is
> greyed
> out. It isn't in all the video tutorials I have watched.
>
> Tried to repeat with various new tables, but it always gives the same
> result.
>
> Activated the edit button on GridView and it allowed me to edit the
> record, but it will not update as DataSource not configured for UPDATE.
>
> What can I be doing wrong ? I am guessing it is a property or a
> permission, but permissions not normally a problem in windows
>
> Help my Test Host expires on Microsoft tomorrow and I can not even get
> to edit an existing table at local level, never mind test how to upload
> and execute on a real host.
>
> Any help appreciated
>
> Richard
>
>
|
Similar Threads
