Click here to Skip to main content
12,077,351 members (50,065 online)
Rate this:
 
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
ibrncfe476
Edited 3-Jan-11 8:49am
Kschuler34.6K
v3
Comments
Toniyo Jackson 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 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 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
Top Experts
Last 24hrsThis month


Advertise | Privacy | Mobile
Web01 | 2.8.160212.1 | Last Updated 23 Apr 2013
Copyright © CodeProject, 1999-2016
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