>Now that I have recieved the data as XML in the server side class, can you recommend a technique for
>getting the data back into the DB?

OK, well, you've already figured out how to get the XML back into the DataSet using the StreamReader with the .ReadXml() method (we include a method that does that in all of our DataSet classes).

And somewhere in this thread, someone (I think Mike), suggested a way for updating your database and it's basically the way that we do things. Here's something I have posted here many times, but it's easier to post it again rather than search for a message <g>:

There are a few more options when updating the database.

First, you can use the Update method of the DataAdapter. In order for this to work, your DataSet must have a PrimaryKey defined.

You can do it using the CommandBuilder, which will generate update commands for you (note: if you use a Stored Proc, the CommandBuilder only generates the proper insert/update/delete commands for the first table retreived from the Stored Proc):

public void UpdateMyData(DataSet ds)
{
	// The same applies for the Update. It's not necessary to Open/Close the connection.
	SqlDataAdapter da = new SqlDataAdapter("select * from bob", this.oConnection);
	SqlCommandBuilder sb = new SqlCommandBuilder(da);

	da.Update(ds);
}

Or you can create the various update commands yourself instead of using the CommandBuilder:

public void UpdateMyData(DataSet ds)
{

	SqlCommand sc = new SqlCommand();
	sc.Connection = this.oConnection;
	da = new SqlDataAdapter(sc);

	da.InsertCommand = new SqlCommand("Insert into bob (xyz, abc) VALUES ( @xyz, @abc )", sc.Connection);
	da.InsertCommand.Parameters.Add("@xyz", SqlDbType.Int, 8, "xyz");
	da.InsertCommand.Parameters.Add("@abc", SqlDbType.VarChar, 50, "abc");

	// do the same for da.DeleteCommand & da.UpdateCommand

	da.Update(ds);
}

Or, you can take total control, not use the da.Update() and do it all yourself (this is basically the same code that gets done behind the scenes by the da.Update() method:

public void UpdateMyData(DataSet ds)
{
	SqlCommand sc = new SqlCommand();
	sc.Connection = this.oConnection;
	sc.Connection.Open();
	foreach (DataRow Row in ds.Tables[0].Rows)
	{
		switch (Row.RowState)
		{
			case DataRowState.Added :
				sc.CommandText = "Insert into bob (xyz, abc) VALUES ( @xyz, @abc )";
				sc.Parameters.Clear();
				sc.Parameters.Add("@xyz", Row["xyz"]);
				sc.Parameters.Add("@abc", Row["abc"]);
				sc.ExecuteNonQuery();
				break;
				
			// Do the same for DataRowState Deleted and Modified
			case DataRowState.Deleted :
				break;
			case DataRowState.Modified :
				break;
		}
	}
	sc.Connection.Close();
}

~~Bonnie