Multiple add before post

Question

Good morning

I would like to create a view where I can enter a information for a list of customer and then post the whole list to the database at then end. I would like to know the best way to achieve this. I am using asp.net mvc with C#

Thank you!

Laxmidhar Sahoo · Answer

hi different ways you can develop. 1- use jquery/javascript/angular/veu/react for client storage 2-may use public static datatable Thanks and Regards Laxmidhar sahoo

Schleid Alex · Answer

I completely understand the process used in this article but on mine I am using an asp.net view, I want to enter information for the first product, hold somewhere, then clear the form to add info for the second product and so on and then at then end post it to the database. I will surely use the technique in this article to pass multiple information to the database for now the issue for me is to have an idea on how to hold or where to store the information until post back. Thank you so much for your time! Alex

Laxmidhar Sahoo · Answer

hi 1 = Create a type in sql server as per table where you want to insert multiple records 2 = Create a stored procedure as input parameter of type that you created Folow the links for above creation 3 = define a datatable in c# as per your table structure and pass it as parameter to the stored proceudure where type is taken as input parameter Bellow is the link for example http://technico.qnownow.com/how-to-pass-datatable-to-stored-procedure-as-table-valued-parameter/ Thanks and Regards Laxmidhar sahoo