what's the best way to pass accepted user inputs to SP

Accepted answer

Yes Venkat For XML is faster compare to other ways Thanks

0

@Manav

But few people say if we pass XML it will be fast and secure is that true?

+1

Hello @Venkat

At last it depends on you that how you manage data

But its not necessary to convert into XML , you can use ,(comma) or for xml

Thanks

0

Thanks for your reply @Manav

when there are multiple values is it necessary to convert it to XMlL and then pass?

+1

Hello @Venkat

From controller code you can pass parameter like :

com.Parameters.AddWithValue("@Column",Column_value); // com is SqlCommand object

And from sql server :

Declare variable within SP declaration like @Column nvarchar(20);

and use it like :

insert into table_nm values(@Name)

Thanks

0