How to insert multiple records in asp .net from Gridview to Sql Database with o

How to insert multiple records in asp .net from Gridview to
Sql Database with out using loop condition ?

Question Posted / sashimeher

Answers were Sorted based on User's Feedback

How to insert multiple records in asp .net from Gridview to Sql Database with out using loop condit..

It is possible to insert many records and just save it to DB
without loop.

Is This Answer Correct ?

11 Yes

1 No

How to insert multiple records in asp .net from Gridview to Sql Database with out using loop condit..

Answer / nahaz nizam

Ya we can do it by using XML.we can send records with XML
format to the procedure as datatype xml in proc

Is This Answer Correct ?

6 Yes

1 No

More ADO.NET Interview Questions

Which method in OLEDBAdapter is used to populate dataset with records?

What are the rules to implement connection pooling?

What is ado.net tutorial?

How to fetch the last inserted record in a particular table?

Define Execute Scalar?

What is ado recordset?

Diff. b/w DataReader and DataSet?

How to find the count of records in a dataset?

If a table contains 20000 records. In a page at each time 100 records to be displayed.

Difference between DataReader and DataAdapter / DataSet and DataAdapter?

What does ole stand for in excel?

What are all components of ADO.Net data provider?

For more ADO.NET Interview Questions Click Here