I want to make some kind of database app!

[dzonov]

Look at my form ..

I don't know how to make database, which i can use.. I want that database to works only on my computer.. Every worker who starts to work in my factory, needs to register.. How to connect databases with my program. The register form contains: Username(txtbox), Password(txtbox), E-mail(txtbox), Register(cmdbtn). When he press register, i want, the program to add that login name and password to the database.. [LOOK AT THE PICTURE]And than .. When someone wrote correctly login name and password, and click login, i want, to my program give him access to the second form.. HOW TO do that ? Please help

 

[TheDeathly]

Okay well, you can do this a few different ways... you can use a MySQL database and have youre program connect to the MySQL database and insert items and read items. or you can have it connected with a TCP client or any one of those, i can help you with either.

Requirements:
TCP Client & Server;
A server - Will recieive the required connections and add the login info to a text file.
MySQL database - A free website would work, OR you can isntall wamp on the "server" computer and host the database youre self. This will take out the need for a server, itll just connect to the database and insert and read from it.
/end requirements

i have used both, so i can be of much help to you.

 

[dzonov]

I need TCP client for program which i want to use only on my computer .. ?
I have one main computer .. Every worker who come need to write that he come.. It's one computer, i don't need to use it on internet ...

 

[Hack]

What kind of database will you be using?

 

[dzonov]

MySQL ...
I looked something that i can connect my program with microsoft access, but i haven't got it, my internet downloads too slow, so i can't download moffice07.. some help for this ?

 

[Hack]

MySQL Connection String Samples - ConnectionStrings.com

 

[dzonov]

This what you gave me is for internet is it ?
I must have server for 10-15 usernames and passwords ???
Is there any chances to put them somewhere on my HD in some tip of object or something else ???? I'm totally beginner in databases.. Please write me PM ..

EDIT: Maybe i'm wrong.. maybe i can do that application without databases ... Correct me if i am wrong please

 

[Hack]

No, that is not for the internet. To connect to ANY type of database, you have to use a connection string.

Each database has its own, individual requirements, when it comes to its connection string. I've never used MySql so I don't have any actual connection strings I could give you which is why I gave the link to that site, which does provide sample connection strings for all different types of databases.

If all you need is 10 or 15 records then why are you using MySQL? Why not MS Access?

 

[mbb]

This what you gave me is for internet is it ?
I must have server for 10-15 usernames and passwords ???
Is there any chances to put them somewhere on my HD in some tip of object or something else ???? I'm totally beginner in databases.. Please write me PM ..

EDIT: Maybe i'm wrong.. maybe i can do that application without databases ... Correct me if i am wrong please

A very simple, but unsecure way of storing objects on disk is to serialise them.

You could represent the fields captured in an object and then represent the table as a collection of those objects e.g. arraylist or dictionary.

Then you can serialise the collection object to disk. Deserialise from disk to memory.



Also, you may find SQL Server Compact serves you better. You can secure by using an encrypted database.

 

[TheDeathly]

Okay, so you have 1 computer, each worker goes to that computer, opens the program, logs in, submits a form and you want to keep track of which person submitted what. and you dont want to have a internet connection. okay, so the only thing ive ever really stored anything is was a .txt file or a mySQL database with wamp. you can use mysql connector for that if you want.
The basics of MySQL connector can be found here by Untamed
http://www.vbdotnetforums.com/remot...ic-net-sql-server-application.html#post109486

 

[dzonov]

Ok, it's over thank you a lot ..