Dim myConn As New SQLConnection(myConnectionString) Dim myCmd AS SQLCommand = Nothing Dim mySql As String = "INSERT INTO myTable(field1, field2) VALUES ('{0}','{1}')" myConn.Open For Each row As DataRow in myDataSet.Rows myCmd = New SQLCommand(String.Format(mySQL, _ row("value1").ToString, _ row("value2").ToString)) myCmd.Connection = myConn myCmd.ExecuteNonQuery Next myConn.Close>Ok, so I have this working. From some Google searchs I get the impression that I need a DataAdapater to
>public void UpdateUser(string sUserXML) >{ > > StringReader oReader = new System.IO.StringReader(sUserXML); > DataSet oDataSet = new DataSet(); > oDataSet.ReadXml(oReader); > >} >>