How to create database which will store data from online website registration

Question

0.00/5 (No votes)

See more:

Hi team,

I have just publish my asp.net project online on my first website.

I have put registration option for users so that I come to know website user data

on local computer, it is easy to store that data in my system SQL server database with normal connection

When we go for online , for storing data like Facebook sign up options etc so How to create that Database ?

Posted 9-Oct-13 20:55pm

Member 10272175

Add a Solution

Comments

JoCodes 10-Oct-13 3:10am

Are you looking to integrate facebook login to your website?

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)

Zafar Sultan · Answer 1 · 2013-10-09T21:02:00

Solution 1

Create script for the DB i.e., tables, SP, triggers, views etc and run it on the remote Database. You must have IP address and credentials for the preproduction/production server. Connect it and test.

Posted 9-Oct-13 21:02pm

Zafar Sultan

Comments

Member 10272175 10-Oct-13 7:06am

Sir I am beginner ....Could you please tell me simple way .........I have IP address..

Zafar Sultan 10-Oct-13 7:12am

Right click on your database, click Tasks>Generate Scripts. After the script is ready run it on the remote server. Database will be created but all the tables will be empty.

Member 10272175 10-Oct-13 8:17am

Yes Sir ...Script is ready ....I got code ..Now How to run that on remote server.. ?

Zafar Sultan 10-Oct-13 8:38am

Connect to the remote server using the IP address and the credentials. Select your database, right click on it and select new query. Paste your script there and click execute or press F5. But since you are saying you are beginner, I would suggest you to perform these tasks under the supervision of a responsible person. There must be other DB's on the server as well. You know what I mean...

Member 10327002 · Answer 2 · 2013-10-09T21:07:00

If you hosted it in localhost systems,then it is so simple,after clicking on registration button,u need to store the data into database by using

SqlCommand cmd = new SqlCommand("insert into Registration(UserID,FirstName,LastName,Address,ContactNo,DOB,Gender,EmailID) values('" + Label17.Text + "','" + TextBox2.Text + "','" + TextBox3.Text + "','" + TextBox4.Text + "','" + TextBox5.Text + "','" + TextBox6.Text + "','" + RadioButtonList1.SelectedItem.Text + "','" + TextBox7.Text + "')", con);