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

What is two way data binding android?

How is entity framework different from ado.net?

Can we connect two dataadapters to same data source using single connection at same time?

How to Handle the exceptions in Sqlsrver2000

Why DataReader is Forward Only?

How can we add relation between tables in a dataset?

How to Read, Add, Update and Delete record in Entity Framework ?

What is openrowset?

What is untyped dataset?

About ado.net components/objects. Usage of data adapters and tell the steps to retrieve data ?

What is the use of SqlCommand object?

What is datasource in ado.net?

For more ADO.NET Interview Questions Click Here