Hi All
I'm trying to transfere data from SQLServer to MSAccess
I've built an oleDbConnection and sqlConnection with 
oleDbDataAdapters and SqlDataAdapters and a dataset, this is done by 
useing drag and drop from the tool box
I'm viewing the data from the SQL Server into a dataGrid then I want 
to transfere it to Access database
I've two buttons:
btnGetData with this code:
sqlDataAdapter1.Fill(dataSet1);
sqlDataAdapter2.Fill(dataSet1); 
        
and the other button btnUpdate with code:
oleDbDataAdapter1.Update(dataSet1, "Customers");
oleDbDataAdapter2.Update(dataSet1, "Orders");

but the update method doesn't work and there is no data transfere to 
the Access DB :(
I think there is something missing in my code, can anyone help?

thank you.




 
Yahoo! Groups Links

<*> To visit your group on the web, go to:
    http://groups.yahoo.com/group/AspNetAnyQuestionIsOk/

<*> To unsubscribe from this group, send an email to:
    [EMAIL PROTECTED]

<*> Your use of Yahoo! Groups is subject to:
    http://docs.yahoo.com/info/terms/
 


Reply via email to