locked
how do you delete a row without deleting it from the table? RRS feed

  • Question

  • User-1794555797 posted

    I what to delete row from a drop down list so the users cannot see it, but I don't want to delete the row from the table. Can someone give my an example SQL stored procedure? 

    Wednesday, September 12, 2012 9:43 AM

Answers

  • User750226543 posted

    You could add a bit field to the table Visible and set this to 1 = visible 0=hidden...

    Then, in your SP...

    SELECT Fields FROM Table WHERE Visible=1

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Wednesday, September 12, 2012 10:39 AM
  • User3866881 posted

    I what to delete row from a drop down list so the users cannot see it, but I don't want to delete the row from the table. Can someone give my an example SQL stored procedure? 

    In you've bounded the DataTable to the GridView,Just see the GridView.Rows[0-based index].Visible = false.

    Reguards!

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Thursday, September 13, 2012 9:10 PM

All replies

  • User750226543 posted

    You could add a bit field to the table Visible and set this to 1 = visible 0=hidden...

    Then, in your SP...

    SELECT Fields FROM Table WHERE Visible=1

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Wednesday, September 12, 2012 10:39 AM
  • User3866881 posted

    I what to delete row from a drop down list so the users cannot see it, but I don't want to delete the row from the table. Can someone give my an example SQL stored procedure? 

    In you've bounded the DataTable to the GridView,Just see the GridView.Rows[0-based index].Visible = false.

    Reguards!

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Thursday, September 13, 2012 9:10 PM