how to save data from Data set into Database

Question

0.00/5 (No votes)

See more:

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 1:25am

ibrncfe

Updated 3-Jan-11 7:49am

Kschuler

v3

Add a Solution

Comments

Toniyo Jackson 3-Jan-11 7:34am

Use pre tag for code.

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

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

Hiren solanki · Answer 1 · 2011-01-03T01:48:00

Solution 1

See the various version of DataAdapter update methods HERE[^].

Posted 3-Jan-11 1:48am

Hiren solanki

Comments

Dalek Dave 3-Jan-11 17:49pm

Good Link

Member 9993496 · Answer 2 · 2013-04-22T18:26:00

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)

Posted 22-Apr-13 18:26pm

Member 9993496

Comments

[no name] 23-Apr-13 7:06am

How exactly is this an answer to this question?