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 are the advantages of Ajax?
What is the limitation of AJAX ?
How will you update multiple records in a single shot? From an ASP.net appli to SQL Serevr
What does the dynamicpopulateextender control do? : asp.net ajax
What is the difference between proxied and proxyless calls in AJAX?
Why did ajax kill himself?
What are the differences between ajax and javascript?
How do I handle the back and forward buttons in ajax?
Is it possible to use fileupload control within the update panel?
Describe the accordionextender control?
Should I consider ajax?
Why do we need ajax?