InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comFri, 24 May 2013 13:32:47 GMT20http://www.sqlservercentral.com/Forums/Topic1003446-1618-1.aspxActually this is an interesting topic, but I would advice using SqlBulkCopy instead, which provide amazing performance, with just a few lines of code:public virtual bool SqlBulkCopy(DataSet ds, string TableName) // provide ability to update any Table in the DS, assume TableName is idem for SQL and App Levelbool result = true;using (SqlBulkCopy BulkCopy = new SqlBulkCopy(MyConnectionString)){ BulkCopy.DestinationTableName = TableName; try { BulkCopy.WriteToServer(ds.Tables[TableName]); // Write from the source to the destination. } catch (Exception e) { // Provide feedback of error issues, to be recovered using something like "DataSetErrorsShower.Show()" ds.Tables[TableName].Rows[0].RowError = ExceptionHandler.WrapSqlException(e); result = false; } if (result == true) ds.Tables[TableName].AcceptChanges(); return result}Hope it helps, keep on comments.Kind Regards,Louis.Fri, 15 Oct 2010 00:49:17 GMTcrackbridgehttp://www.sqlservercentral.com/Forums/Topic1003446-1618-1.aspxI got an Idea how to Send multiple rows to the Database from an Application and from the below code we can even insert it to the table as u showed in the Articlelike,consider a table EmpINSERT INTO Emp (Name, Salary)SELECT Name, Salary FROM OPENXML (@idoc, '/ROWS/ROW', 1)WITH (Name varchar(50), Salary int)WHERE Salary >= 1500ORDER BY NameMy Doubt is about how to Update multiple rows in Emp table using the below xml query<ROWS><ROW> <ID>1</ID><Name>Tom</Name> <Salary>21000</Salary> </ROW><ROW> <ID>2</ID><Name>Nitesh</Name> <Salary>18000</Salary> </ROW><ROW> <ID>3</ID><Name>Mat</Name> <Salary>15000</Salary> </ROW></ROWS>Please help me out for updating the table with above xml QueryThank and Regards Nitesh katareWed, 13 Oct 2010 03:49:51 GMTNitesh katare