How to Create a Web Interface SQL to Populate a Database
The Microsoft .NET Frameworks works with the SQL Server database to store information in the tables. The information entered into a Web page form stores to the SQL database using a database connection and query. The drivers and classes used to send the information to the database are supplied by the .NET Framework. Use these two applications together to populate a database table with information.
Other People Are Reading
Instructions
-
-
1
Open the Visual Studio software from the Windows program menu. Open your Web project and double-click the form you want to use to create the input form.
-
2
Drag and drop a text box control from the VS toolbox to the form. In the Properties panel, name the text box "name." This text box allows users to insert a name that is inserted into the database table. Add additional text boxes for each piece of data you want to insert into the database.
-
-
3
Double-click the source code file for the Web page form. Add the following code to the top of the file to import the necessary namespace:
using System.Data;
using System.Data.SqlClient; -
4
Scroll down to the "Submit" event to add the code that inserts the data into the database. Create a database connection. Add the following code to connect to the SQL Server:
SqlConnection connect = new SqlConnection("server=localhost;uid=username;pwd=password;database=db;")
connect.Open();Replace the username and password with your own. Change "db" with the name of your database.
-
5
Insert the data into the SQL Server tables. The following code inserts the "name" text box into the database table "customers":
SqlCommand sqlComm = new SqlCommand("insert into customers (name) values ('" + name.Text + "'", connect);
You add each text box in the "insert" statement to add more data to the table.
-
6
Click the "Save" button and "Run" to run the page in the VS debugger. Enter information and click "Submit" to insert data into your database.
-
1
