Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
gt11990
Starting Member
2 Posts |
 Posted - 2011-10-12 : 18:35:04
|
| Basically i want to know if there is a way to link a database full of questions and answers to a website drop down selection box and want to know if there is a way to delete a question which is answered form the database so to put it in simple termswhen a user answers the question right that question should be deleted form the database and replaced by a new question for a new user to answerthank you |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-10-13 : 01:40:42
|
| create a recordset in your front end language to get the question answer details and using presentation layer code populate dropdown with values from recordset. The deletion can be done by adding code on submit action of page to capture question/answer selected and comparing it with db value and delete it if correct. You can use sql procedure for doing it------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
gt11990
Starting Member
2 Posts |
Posted - 2011-10-13 : 14:34:18
|
| Oh my, ok i partially understand what you wrote but i am new to sql and i wish i knew how to do all that just gotta research about it then, i wonder if there is any tutorial lessons online to show me how to do the stuff you told methanks |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
|
|
|
|
|
Lost need help