Update table using table datatype

Hi Deepak,

Please check if the following code is what helps in your task:

SQL Code below:
CREATE TYPE TYPANSWERCHOICE AS TABLE(
ANSID INT,
QID INT,
ANSWERCHOICE NEXT
)
GO

CREATE PROCEDURE INSERTANSWERCHOICE(
@ANSWERCH AS TYPANSWERCHOICE READONLY)
AS
BEGIN

INSERT INTO [tblAnswerChoice]
SELECT * FROM @ANSWERCH

END
GO

C# code below:
using (var conn = new SqlConnection("CONNECTIONSTRING"))
{
conn.Open();
using (var cmd = new SqlCommand("INSERTANSWERCHOICE", conn))
{
cmd.CommandType = CommandType.StoredProcedure;

var answerParam = cmd.Parameters.AddWithValue("@ANSWERCH", ANSWERDATATABLE);

answerParam.SqlDbType = SqlDbType.Structured;

cmd.ExecuteNonQuery();
}
conn.Close();

Please do not forget to mark "Accepted Answer".

Hi,

I have no experience with passing datatable to stored Procedure.You  may try this.