Click here to Skip to main content
Rate this: bad
good
Please Sign up or sign in to vote.
See more: VB8.0
Hello all, Newbie all around here, in VB as well as this forum.
 
I am starting to learn the realms of VB. Having intermediate knowledge on HTML/PHP/MySQL code, I find VB to be easier to learn.
 
With that said, please treat me as a newbie. Smile | :)
 
My question is as the title states: I need to have a direction on how to create a snippet of code.
 
I would like for my users to click on a button or menu entry and be able to import/export the data in a table, for backup purposes. Í have no code to show as I don't even know where to begin. Not asking for you to do my work, just an example or a point to the right direction will do, as I have been looking for 2 days all over Google and I am starting to get frustrated.
 
It would be super nice to have it all contained inside the little project, and no API or third party tools, so I can actually learn what I am doing.
 
This is a project that may be going nowhere, I am just trying to learn. Then again, could be the basis for a few ideas I have...
 
Thanks!
Posted 23-Jul-10 10:15am
Edited 23-Jul-10 10:21am
v3
Comments
TheyCallMeMrJames at 23-Jul-10 16:34pm
   
Reason for my vote of 5
Good honest question from someone who isn't assuming they are 'l33t' and gracing us with their question.
TheyCallMeMrJames at 23-Jul-10 16:41pm
   
Are you working on a Windows application or a web site?
Mordred69 at 24-Jul-10 0:18am
   
I thought I had written an answer to this about 5 minutes after you posted this, MrJames... I guess I did not click on the "Submit Comment" or it just didn't post.
 
This is a very basic Windows application. What I am trying to accomplish is to learn how to take the data from a table and put it on a CSV or a txt file. The user should be able to then take that csv or txt file and save it someplace as a data backup and then be able to import it.
 
Thank you.

1 solution

Rate this: bad
good
Please Sign up or sign in to vote.

Solution 1

I would expect that you would not work with the control at all. Your data table will be built typically from a data source, such as a dataset. As a result, I would consider the data table to only be a view to the data, and work with the data directly to create the file you want. The File class has static methods like WriteAllText and WriteAllLines, so I would iterate over the data source, create a string array ( I'd probably use the List class and call ToArray at the end ), then call a method to save the data.
  Permalink  
Comments
Mordred69 at 24-Jul-10 0:22am
   
Thank you, Christian Graus. Now, can you (or anyone else, for that matter) point me as to how I go about gathering the information from the datatable?
 
The main roadblock for me now is, I don't really know how to construct the query code inside the vb form so I can use with a click event. By using the snippets provided inside the program, I can see how to make a database connection, but I am not sure how to go start the query.
 
I will keep looking around google to see if I can learn something. Thanks for the logical explination; I can now see how I can build this, at least the file creation side.

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

  Print Answers RSS
0 OriginalGriff 341
1 Marcin Kozub 225
2 Praneet Nadkar 197
3 Sergey Alexandrovich Kryukov 190
4 Shweta N Mishra 161
0 OriginalGriff 8,149
1 Sergey Alexandrovich Kryukov 7,287
2 DamithSL 5,614
3 Manas Bhardwaj 4,986
4 Maciej Los 4,910


Advertise | Privacy | Mobile
Web04 | 2.8.1411023.1 | Last Updated 24 Jul 2010
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