creation a data base and how to

Question

0.00/5 (No votes)

See more:

Sweet day
I need to know how to creation a data base in asp .net
and how to creation a table
and i need to know how conection between my sql (data base) and between my
code
eg. if i create screen consist a user name and password
i know i need to create a table in data base consist a user name conection with user
name so the user name and password in the screen read in data base thats i create it
and thanks for all

Posted 21-Mar-11 11:18am

ahmad jadoa

Add a Solution

2 solutions

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)

CDP1802 · Answer 1 · 2011-03-21T11:36:00

To be honest, the answers to your questions could fill books and is a little too much to be answered quickly.

It would be best to read some articles on database design first. Then you must look at SQL in order to learn how to insert and retrieve data into and from the database. After that you will need to do some reading about ADO .Net, especially on how to use the SqlConnection, SqlCommand and SqlParameter objects in order to send SQL commands to the database and receive the results. Most articles will be about MS SQLServer, so it's better to start with this first.

Just do a little search here in the articles and you will certainly find a few articles on any of those subjects. It will probably take a little time and distract you from what you want to do, but after that you will understand a little more about databases and get on with your project a little easier.

Last you will need to download the current version of the .Net connector for the MySQL database. It works similar to the objects uses for MS SQLServer, but it's not 100% identical.

Henry Minute · Answer 2 · 2011-03-21T11:38:00

Solution 2

Here[^] is a step by step tutorial, although if you do not yet know how to create a database and a table you might struggle a little with it.

Posted 21-Mar-11 11:38am

Henry Minute