Click here to Skip to main content
Rate this: bad
good
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
good
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.
Steps:
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 C#.net[^]
  Permalink  
v2

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

  Print Answers RSS
0 CHill60 210
1 Sergey Alexandrovich Kryukov 200
2 Peter Leow 170
3 Richard Deeming 166
4 Zoltán Zörgő 135
0 Sergey Alexandrovich Kryukov 9,278
1 OriginalGriff 6,806
2 Peter Leow 4,432
3 Zoltán Zörgő 3,944
4 Richard MacCutchan 2,782


Advertise | Privacy | Mobile
Web02 | 2.8.150129.1 | Last Updated 15 Jan 2013
Copyright © CodeProject, 1999-2015
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