473,320 Members | 2,027 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

CSV to SQL by C++

Hello people,

I am new to C++ and my first task is to create a program that when run by users, it will import the data in a csv file into sql database. I wonder if it is possible or not and if it is possible, please give me some sample source code.

Much appreciated.

Regards
Jul 9 '09 #1
5 2129
Curtis Rutland
3,256 Expert 2GB
Well, it is very much possible. I'm assuming you're using Visual C++ and the .NET Framework? Most of our experts in the .NET forum tend to deal with VB.NET and C# though.

So I'm going to link you a few good resources.

Some namespaces you need to study to do this:
System.IO
Make sure to look up StreamReader.
System.Data
Make sure to look up DataSet and DataTable.

Here are some articles on this site that deal with databases. Note that the sample code is in C# / VB.NET, so you might have to do a little translating.
http://bytes.com/topic/net/insights/...e-your-program
http://bytes.com/topic/net/insights/...rogram-part-ii
Jul 9 '09 #2
First of all, thank you very much for your reply and advices.

Yes, I'm trying with both Visual Basic 2008 and Visual C++ 2008. The problem is that I havnet learnt these languages before. As a requirement for a project, I have to create a small application that can import csv file automatically to SQL 2000 (and need to be done in few days). Therefore, If you know any opensource code or demo, please let me know. Thank you in advance.

Regards
Jul 9 '09 #3
Plater
7,872 Expert 4TB
We cannot do assignments for you, but I can give you a bit more advice.
Start with the first part, you need to be able to parse a CSV into some kind of data structure in your code (I recomend the DataTable object)
Find a way to populate your object with the data contained in the CSV, and you half done.
Jul 9 '09 #4
Hello,

Is there any other reference? I have tried How To Use A Database In Your Program instruction and it seems I got connection but then I cannot run bulkcopy.

Regards
Jul 10 '09 #5
Plater
7,872 Expert 4TB
You're going to actually have to do it "by hand" so to speak.
Jul 10 '09 #6

Sign in to post your reply or Sign up for a free account.

Similar topics

3
by: William C. White | last post by:
Does anyone know of a way to use PHP /w Authorize.net AIM without using cURL? Our website is hosted on a shared drive and the webhost company doesn't installed additional software (such as cURL)...
2
by: Albert Ahtenberg | last post by:
Hello, I don't know if it is only me but I was sure that header("Location:url") redirects the browser instantly to URL, or at least stops the execution of the code. But appearantely it continues...
3
by: James | last post by:
Hi, I have a form with 2 fields. 'A' 'B' The user completes one of the fields and the form is submitted. On the results page I want to run a query, but this will change subject to which...
0
by: Ollivier Robert | last post by:
Hello, I'm trying to link PHP with Oracle 9.2.0/OCI8 with gcc 3.2.3 on a Solaris9 system. The link succeeds but everytime I try to run php, I get a SEGV from inside the libcnltsh.so library. ...
1
by: Richard Galli | last post by:
I want viewers to compare state laws on a single subject. Imagine a three-column table with a drop-down box on the top. A viewer selects a state from the list, and that state's text fills the...
4
by: Albert Ahtenberg | last post by:
Hello, I have two questions. 1. When the user presses the back button and returns to a form he filled the form is reseted. How do I leave there the values he inserted? 2. When the...
1
by: inderjit S Gabrie | last post by:
Hi all Here is the scenerio ...is it possibly to do this... i am getting valid course dates output on to a web which i have designed ....all is okay so far , look at the following web url ...
2
by: Jack | last post by:
Hi All, What is the PHP equivilent of Oracle bind variables in a SQL statement, e.g. select x from y where z=:parameter Which in asp/jsp would be followed by some statements to bind a value...
3
by: Sandwick | last post by:
I am trying to change the size of a drawing so they are all 3x3. the script below is what i was trying to use to cut it in half ... I get errors. I can display the normal picture but not the...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.