G
Guest
Hello
I need to transfer data from Access to MS SQL Server, so I craete DataSet, Fill it from Access and try to Update() it to SQL Server, but tables still empty. Why? Here is my code
<code
sqlServerConn.Open();
SqlDataAdapter modelsTableAdapter = new SqlDataAdapter("SELECT * FROM AS_PARKERS_MODELS", sqlServerConn)
DataSet myDataSet = new DataSet(); // fill DataSet from SQL Server (really no data is here
modelsTableAdapter.Fill(myDataSet, "AS_PARKERS_MODELS")
// MS Access adapte
OleDbDataAdapter modelsAccessAdapter = new OleDbDataAdapter("SELECT * FROM models", accessConn)
// Fill the same DataSet from Access
modelsAccessAdapter.Fill(myDataSet, "AS_PARKERS_MODELS");
// try to save changes to SQL Serve
modelsTableAdapter.Update(myDataSet, "AS_PARKERS_MODELS")
sqlServerConn.Close()
</code>
I need to transfer data from Access to MS SQL Server, so I craete DataSet, Fill it from Access and try to Update() it to SQL Server, but tables still empty. Why? Here is my code
<code
sqlServerConn.Open();
SqlDataAdapter modelsTableAdapter = new SqlDataAdapter("SELECT * FROM AS_PARKERS_MODELS", sqlServerConn)
DataSet myDataSet = new DataSet(); // fill DataSet from SQL Server (really no data is here
modelsTableAdapter.Fill(myDataSet, "AS_PARKERS_MODELS")
// MS Access adapte
OleDbDataAdapter modelsAccessAdapter = new OleDbDataAdapter("SELECT * FROM models", accessConn)
// Fill the same DataSet from Access
modelsAccessAdapter.Fill(myDataSet, "AS_PARKERS_MODELS");
// try to save changes to SQL Serve
modelsTableAdapter.Update(myDataSet, "AS_PARKERS_MODELS")
sqlServerConn.Close()
</code>