Configure SqlDataSource problem

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Lars - 14 Feb 2008 04:02 GMT

Hi

I have another problem as well. For some reason the Configuration of the
SQLSataSource doesn't allow me to select the commands Insert, Update and
Delete. They are grayed. HOwever I seam to be able to make INsert by adding
SQL commands (with parametrized values). It's when I try to make an edit
form for the values that takes care of the SQL Insertion problem that I
can't Insert, Update or Delete.

Lars

Reply to this Message

Manish - 14 Feb 2008 10:40 GMT

Hi Lars,

If the table you are loading in the SQLDataSource does not contain the
Primary key then you would not be able to generate the Update,delete and
insert command. If your table has a primary key then you can select the
Advanced button and then check the option to automatically generate the
update,insert and delete command for you.

Regards,
Manish

www.ComponentOne.com

> Hi
>
[quoted text clipped - 7 lines]
> Lars
>

Reply to this Message

Free Magazines

Get these publications absolutely FREE for up to 12 months. There are no hidden fees and no obligation. Simply choose a title, complete the application form and submit it. Read more ...