Configure SqlDataSource problem

Collapse
This topic is closed.
X
X
 
  • Time
  • Show
Clear All
new posts
  • Lars

    Configure SqlDataSource problem

    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



  • =?Utf-8?B?TWFuaXNo?=

    #2
    RE: Configure SqlDataSource problem

    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

    MESCIUS USA Inc. has JavaScript and .NET UI controls, datagrids, reporting solutions, spreadsheets, document APIs and more to take your applications further.


    "Lars" wrote:
    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
    >
    >
    >
    >

    Comment

    Working...