Configure SqlDataSource problem

[Lars]

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

 

[Manish]

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