How to create simple c++ database on visual studio ?

[PureEvil75]

Hello
I wanted to make a simple database of Name , ID etc.
please I want full illustration from A to Z
REGARDS

[Pickle Gunner]

Any more details than that?

[PureEvil75]

•Write a C++ program that stores the data of employees working in a company. The employees’ data include: ID, name, address, rank, hours worked, and overtime hours.
System Functions :
•Add a new employee.
•Edit the data of stored employees.
•Calculate the payment of stored employees.
•Search for a certain employee and display his/her data.
•Calculate the average payment for all employees.

That's what I wanna do store it and then recall it easily and edit it

[debanka]

Check this out ..

w.codeproject.com/Articles/22711/Using-Database-in-your-MFC-program-A-beginner-s-ex

[PureEvil75]

Please can u re-write the URL
cuz this page does not exist
http://www.codeproject.com/script/Articles/Using-Database-in-your-MFC-program-A-beginner-s-ex

and this site says http://www.codeproject.com/Articles/Using-Database-in-your-MFC-program-A-beginner-s-ex
The member requested was not found.
.....what I can I do ?

[cnoeval]

Show a least a LITTLE effort man. Google "visual c++ database tutorial" and you will find dozens of tutorial, videos, examples, etc. Then, post back at a forum like this with SPECIFIC questions if you get stuck.

[PureEvil75]

thx

[3qX21hU5]

•Write a C++ program that stores the data of employees working in a company. The employees’ data include: ID, name, address, rank, hours worked, and overtime hours. 
System Functions :
•Add a new employee. 
•Edit the data of stored employees. 
•Calculate the payment of stored employees. 
•Search for a certain employee and display his/her data. 
•Calculate the average payment for all employees. 

From that it seems like your teacher wants you to write a program that acts like a timesheet program for a workplace. This is a pretty complicated program so I am assume you are familiar with classes and most of the basics of C++.

So like cnoeval said do some research on how to go about it, and then come back with some code of yours and we will help guide you in the right direction.

[PureEvil75]

ok what's wrong here :
the seachname function is not working !!

#include <iostream>
#include <string>
#include <fstream>
using namespace std;
void input () ;
void searchname () ;
int main ()
{
	system ("title simple data base !") ;
	system ("CLS");
	int choice ;
	system ("color 0F");
	cout << "Press 1 : to Input a new data" << endl;
	cout << "Press 2 : for Searching by name" << endl;
	cout << "Press 3 : to Exit" << endl;
	cin >> choice ;
	
	if (choice == 1)
	{
		input () ;
	}

	else if (choice == 2)
	{
	    searchname () ;
	}
}

void input () 
{
	string name ;
	int ID , salary ;
	ofstream worker ("worker.text",ios ::app) ;
	cout << "Please Enter your name : " ;
	cin >> name ;
	cout << "Please Enter your ID : " ;
	cin >> ID ;
	cout << "Please Enter your salary : " ;
	cin >> salary ;

	worker << name << ' ' << ID << ' ' << salary << endl;
	worker.close () ;
	cout << endl;
	main () ;
}


void searchname () 
{
	system ("cls") ;
	string name , str ;
	int salary , ID ;
	ifstream worker ("worker.txt") ;
	cout << "Enter the Name : " ;
	cin >> str ;
	while (worker >> name >> ID >> salary)
	{
		if (str == name)
		{
			system ("cls") ;
			cout << "The Worker has been found !" << endl;
			cout << "Name" << ' ' << "ID" << ' ' << "Salary"<< endl;
			cout << "---------------" << endl;
			cout << name << ' ' << ID << ' ' << salary << endl;
		}

		else if (!(str == name))
		{
			system ("cls");
			cout << "Not found !"<< endl;
		}
	}
	system ("Pause") ;
	cin.get () ;
	main () ;
}

[Vidminas]

Maybe it's just me, but what does while (worker >> name >> ID >> salary) mean?

I think that might be your problem...

Yeah, it's just me :D Sorry..

[PureEvil75]

it means go to the worker text and memorize the values of name and ID and Salary and then if str == name , cout the corresponding ID Salary
and Thanks any way

[PureEvil75]

WOWOWO!!!
hang on a minute.....I've created another prototype and It works !!
here it is :

# include <iostream>
# include <string >
# include <fstream>
using namespace std ;
void name () ;
void ID () ;
int main ()
{
	system ("cls") ;
	system ("color 0F") ;
	int ch1 ;
	cout << "1 for new data" << endl;
	cout << "2 for seaching by ID" << endl;
        cin >> ch1 ;
	if (ch1 == 1)
	{
		name () ;
	}
	else if (ch1 == 2)
	{
		ID () ;
	}

}

void name ()
{
	system ("cls") ;
	string name ;
	ofstream worker ("eslam.txt",ios ::app);
	int ID , salary ;
	cout << "Name : ";
	cin >> name ;
	cout << "ID : " ;
	cin >> ID ;
	cout << "Salary : " ;
	cin >> salary ;

	worker << name << " " << ID << " " << salary << endl;
	worker.close () ;
	cin.get () ;
	main () ;
}

void ID ()
{
	ifstream worker ("eslam.txt") ;
	int ID , salary , str ;
	string name  ;
	cout << "Enter ID : " ;
	cin >> str ;

	while (worker >> name >> ID >> salary)
	{
		if (str == ID)
		{
			system ("cls") ;
			cout << "Data found !" << endl;
			cout << name << " " << ID << " "  << salary << endl; 
		}

		else if (!(str == ID))
		{
			system ("cls") ;
			cout << "Not Found !" << endl;
		}
	}

	system ("pause") ;
	main () ;
}

but why the main one not working