User Name Password Register
DaniWeb IT Discussion Community
All
What is DaniWeb IT Discussion Community?
You're currently browsing the ASP.NET section within the Web Development category of DaniWeb, a massive community of 397,816 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 2,622 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.
Please support our ASP.NET advertiser: Lunarpages ASP Web Hosting
Views: 2381 | Replies: 3 | Solved
Reply
Join Date: Mar 2007
Posts: 14
Reputation: someoneelse is an unknown quantity at this point 
Rep Power: 2
Solved Threads: 0
someoneelse someoneelse is offline Offline
Newbie Poster

Help Problem Inserting into SQL database on server

  #1  
Apr 25th, 2007
I am using visual devloper express, and i have been following allow in the "starter videos". for lesson 8 (editing and insterting into a sql express db file on the local host), the example worked fine, but when i try to replicate the example with a SQL database (external one) when I am configuring the formView, and i try to click the advanced tab under 'Advanced SQL Generation Options", I do not have the abilty to check the 2 boxes for generate insert, update, delete statements, etc (they are greyed out).

i have an asp page that has the same connection as this page and i am able to insert a record, so i am sure it's not a permission thing...

does anyone else know how to solve this problem, or has it occured for someone else? I am at a loss....I don't understand what I am doing wrong here... a plain old asp coded page inserts records into this table in the same database, but I am unable to check the boxes for "generate insert" etrc, and the error I get on the page itself is

Inserting is not supported by data source 'SqlDataSource1' unless InsertCommand is specified.





Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.NotSupportedException: Inserting is not supported by data source 'SqlDataSource1' unless InsertCommand is specified.
AddThis Social Bookmark Button
Reply With Quote  
Join Date: Feb 2005
Location: Braintree, UK
Posts: 1,164
Reputation: hollystyles will become famous soon enough hollystyles will become famous soon enough 
Rep Power: 7
Solved Threads: 58
hollystyles's Avatar
hollystyles hollystyles is offline Offline
Veteran Poster

Re: Problem Inserting into SQL database on server

  #2  
Apr 25th, 2007
Did you set your id column as a primary key in the external database? This prevents the generate sql statements being available as it can't generate sql for tables that don't have a primary key.
==========================================
Yadda yadda yadda...
Web junky, fevered monkey
Reply With Quote  
Join Date: Mar 2007
Posts: 14
Reputation: someoneelse is an unknown quantity at this point 
Rep Power: 2
Solved Threads: 0
someoneelse someoneelse is offline Offline
Newbie Poster

Re: Problem Inserting into SQL database on server

  #3  
Apr 26th, 2007
THANK YOU SO MUCH!

I was going crazy and that solved my problem in less than 1 minute

~ Andrea
Reply With Quote  
Join Date: Feb 2005
Location: Braintree, UK
Posts: 1,164
Reputation: hollystyles will become famous soon enough hollystyles will become famous soon enough 
Rep Power: 7
Solved Threads: 58
hollystyles's Avatar
hollystyles hollystyles is offline Offline
Veteran Poster

Re: Problem Inserting into SQL database on server

  #4  
Apr 26th, 2007
I know! I've been there too many times
==========================================
Yadda yadda yadda...
Web junky, fevered monkey
Reply With Quote  
Reply

Only community members can participate in forum threads. You must register or log in to contribute.

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)

 

DaniWeb ASP.NET Marketplace
Thread Tools Display Modes

Similar Threads
Other Threads in the ASP.NET Forum

All times are GMT -4. The time now is 6:38 am.
Forum system based on vBulletin Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
©2003 - 2008 DaniWeb® LLC