Click here to Skip to main content
Rate this: bad
good
Please Sign up or sign in to vote.
See more: SQL Server
Hello everybody,
 
I am going to write program with VB.net and use data base (type SQL Server Compact Edition) with connectionless mode by using Data Set , but I have a problem in how to save data (new) from data set into database SDF file (old data). I heard that there is an instruction or method in data set can make that.... i need help.
 
I used this code to insert data into data set
mydataset.mytableadapter.insert(P1,P2,P3)
mytableadapter.update(mydataset)
Posted 3-Jan-11 2:25am
ibrncfe468
Edited 3-Jan-11 8:49am
Kschuler33.3K
v3
Comments
Toniyo Jackson at 3-Jan-11 7:34am
   
Use pre tag for code.
Rate this: bad
good
Please Sign up or sign in to vote.

Solution 1

See the various version of DataAdapter update methods HERE[^].
  Permalink  
Comments
Dalek Dave at 3-Jan-11 17:49pm
   
Good Link
Rate this: bad
good
Please Sign up or sign in to vote.

Solution 2

i see that you're programming using sdf files.
do you know about .sdf files? its use for databases. i am going to make a sdf viewer but i dont know where to start. can you help me?
i need to make a sdf viewer application using vb.net (window-based)
  Permalink  
Comments
ThePhantomUpvoter at 23-Apr-13 7:06am
   
How exactly is this an answer to this question?

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

  Print Answers RSS
0 Zoltán Zörgő 220
1 Sergey Alexandrovich Kryukov 180
2 Peter Leow 160
3 BillWoodruff 85
4 bling 80
0 Sergey Alexandrovich Kryukov 9,543
1 OriginalGriff 6,901
2 Peter Leow 4,737
3 Zoltán Zörgő 4,404
4 CHill60 2,932


Advertise | Privacy | Mobile
Web04 | 2.8.150129.1 | Last Updated 23 Apr 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