import and export data from asp.net

Question

1.00/5 (2 votes)

See more:

Hi I am trying to find a solution to export data from my database but i don't know what is the best approach .
simply, i will upgrade my project in the future and i don't want to lose my data plus maybe, i add some new tables in the future and maybe some columns to the current tables .

so what should i do with that ?

Thanks in advance.

Posted 3-Aug-13 23:54pm

Ahmad Abd-Elghany

Add a Solution

Comments

ridoy 4-Aug-13 6:06am

you you want to export data from database then use datagirdview which will update with your database edit,and keep editing feature in your datagrid so that you can update your database through it.

1 solution

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)

**Zoltán Zörgő** · Answer 1 · 2013-08-04T00:08:00

Solution 1

Your question is not well defined. Nobody can tell what's the best for your porposes, but as I see, you don't need any export, just create a backup of your database. In the future you can restore it into a different one, and do what you want. Exporting is good when you have import somewhere - most likely in a totally different system.

See backup and restore[^] in SQL Server.

Posted 4-Aug-13 0:08am

Zoltán Zörgő

Comments

Ahmad Abd-Elghany 4-Aug-13 6:11am

but i will add some new tables , can i restore the data into tables ?

Zoltán Zörgő 4-Aug-13 6:22am

No, but once you have the two databases side-by side, you can uset t-sql and issue select-into statements from one database into the other - or anything else you want. It is the most flexible approach in your case. If you export it to any format, you will still need to import into a different table to do any processing.