How will you update multiple records in a single shot?
From an ASP.net appli to SQL Serevr
Answers were Sorted based on User's Feedback
Answer / mithun
Create a data table. add mulitple records to it. pass it as datatable to stored procedure.
in DAO, pass datatable as single parameter of type SqlType.Structured.
in SQL, create a user defined datatype of table with same structure u pass from web. select the column values from table datatype an insert into table.
| Is This Answer Correct ? | 2 Yes | 1 No |
What is the asp.net ajax framework?
Which is the purpose for using the scriptmanager?
What are the real web applications of ajax currently running in the market?
What are the ajax security issues?
How do I access data from other domains to create a mashup with java?
Is ajax a framework?
What is asp.net ajax? : asp.net ajax
What is update panel?
Why do we use the updateprogress control in ajax? : asp.net ajax
How many types of ready states in Ajax?
What are the difference between AJAX and Javascript?
How can AJAX applications be debugged?