How to pass hashtable in store procedure in asp.net.

Question

hi friends...

i am developing a web application in three tier architecture. And i want to use hash table with store procedure.
I want to bind the all value of control of form and pass through the store procedure for saving in DB.

I have no idea that how we can bind and insert the value through store procedure.

Thanks & Regards..
Mukesh Kumar Tiwari

Hemant Srivastava · Answer

You can pass parameters either having regular datatypes (int varchar bool float etc.) or a table Here are some articles which would be helpful for you to understand parameters passing. How to pass parameters in stored proc: http://www.c-sharpcorner.com/UploadFile/4624e9/stored-procedures-in-C-Sharp/ How to pass table values parameter in a stored proc: http://www.c-sharpcorner.com/UploadFile/rohatash/passing-table-to-a-store-procedure-parameter-in-sql-server-2/

Anurag Sarkar · Answer

You can use datasets.