<snip>
>SqlCommandBuilder oBuilder = new SqlCommandBuilder(oDataAdapter);
>oDataAdapter.Update(oDataSet, oDataSet.Tables[0].TableName);
>This throws an error because there is no data adapter. It works if I do:>string sSelectCommand = "select * from Customers where CustomerKey = 1"; >SqlDataAdapter oDataAdapter = new SqlDataAdapter(sSelectCommand, oConnection);>before hand. But my question is that this seems to be making a call into the DB just to save a new record.