Using both oracle db and access for one gridview
<p>I would like to add some functionality to a gridview I have. Essentially I just want to do something similar to AutoGenerateInsert button that asp.net 2.0 does. I want the fields to push data to an AccessDataSource. The trick here though is that I want to verify some fields against an Oracle DB and even auto-populate other fields to what a user has input for a field.. As an example, my Oracle DB has personal information such as names, ages, etc. If the web-app user types in a valid name in a 'Name' field, then the field should be validated and other personal info should be auto-populated. Once all the fields are have been entered then the 'Add' button is clicked and that new record on the gridview inserts the data to an Access DB.</p>

<p>Any links or hints out there for accomplishing something like this?</p>

<p>Thanks!
-doddy</p>
