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.2K
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 OriginalGriff 330
1 Sergey Alexandrovich Kryukov 279
2 BillWoodruff 245
3 Afzaal Ahmad Zeeshan 215
4 CPallini 205
0 OriginalGriff 5,635
1 DamithSL 4,496
2 Maciej Los 3,942
3 Kornfeld Eliyahu Peter 3,480
4 Sergey Alexandrovich Kryukov 3,180


Advertise | Privacy | Mobile
Web04 | 2.8.141216.1 | Last Updated 23 Apr 2013
Copyright © CodeProject, 1999-2014
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