locked
Advance SQL Generation Option (Sqldatasource) RRS feed

  • Question

  • User595945745 posted

    Hello

    i am use sqldatasource in asp.net page and need to use Advance SQL Generation Option for update,delete,edit table date but Advance SQL Generation Option is Disable by default.......how to enable this option plzzzz help me............

    Tuesday, August 12, 2014 11:40 PM

Answers

  • User-821857111 posted

    You need to make sure that the Select statement includes the primary key.

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Wednesday, August 13, 2014 9:05 AM
  • User-1716253493 posted
    Apologize, i have misunderstood. Mikesdotnett is right, make sure you have primary key i.e ID, you should check the key before go to advance sql option.
    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Wednesday, August 13, 2014 9:17 AM

All replies

  • User-1716253493 posted

    Maybe you can right click sqldatasource => properties

    You can modify select/update/insert command from there

    Tuesday, August 12, 2014 11:48 PM
  • User-821857111 posted

    You need to make sure that the Select statement includes the primary key.

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Wednesday, August 13, 2014 9:05 AM
  • User-1716253493 posted
    Apologize, i have misunderstood. Mikesdotnett is right, make sure you have primary key i.e ID, you should check the key before go to advance sql option.
    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Wednesday, August 13, 2014 9:17 AM