Click here to Skip to main content
12,814,249 members (39,040 online)
Rate this:
Please Sign up or sign in to vote.
See more: C#
How to Use DataRow for Insert Data in To Table(Access2007)
Posted 15-Jan-13 5:54am

1 solution

Rate this: bad
Please Sign up or sign in to vote.

Solution 1

Insert will be same as we do for any table or database. Using ADO.NET standard commands, one can create/edit/delete the records.
1. Open connection (will be different based on DB)
2. Form a command
3. Provide query to command
4. Provide parameters to command using the input data you have (is that in datarow?)
5. Execute command
6. Close connection.

Try out please.
Following articles will guide you more:
Simple ADO.NET Database Read, Insert, Update and Delete using C#.[^]
Creating & Retrieving records from M.S.Access-2007 using Oledb in[^]

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

    Print Answers RSS
Top Experts
Last 24hrsThis month

Advertise | Privacy | Mobile
Web02 | 2.8.170308.1 | Last Updated 15 Jan 2013
Copyright © CodeProject, 1999-2017
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100