Update table using table datatype

Oct 9 2011 6:51 AM
Hello,

I am facing some problem in passing data table parameter to stored procedure.

There are two table 
tblQuestion and tblAnswerChoice

1. tblQuestion is for storing questions and its columns are
a)Qid int primary key identity
b)Question ntext
c)Createiondate datetime

2. tblAnswerChoice is for storing Answer Choices for the particular question and its columns are
a)Ansid int primary key identity
b)qid int 
c)AnswerChoice ntext
 

Now about the problem I want to update the data of the tblAnswerChoiceI am passing the datatable as parameter to the datatabse. I need the stored procedure for updating the datatbase. Is is possible using table datatype or not. If yes then how to write the stored procedure for update thetblAnswerChoice. If table stored procedure is not use in this case, how can I update thetblAnswerChoice
 
Thanks,
Deepak Pandey

Answers (3)