So are you ready to learn how to insert data into a database in ASP.NET. This article will explain step-by-step how to insert data into a database for your web purposes, like:
- Sessions
- User Interaction Page
- Registration Page
- Contact info Page and so on.
Procedure
Step 1
Coding in Class File Page (.cs)
We need code in a .cs file. First of all we need to attempt to add a special file type (class) to an ASP.NET website. In general to use this type of item in your site, you should place it in the "App_Code" folder.
Use the following procedure to do that:
- Open a empty ASP.NET website
- Click on Solution Explorer
- Then right-click on C:\...\website1
- Add a new item
- Select Class file from there and "Add"; a new window like this will open:
In this page, code according to this:
// APP_Code/Class1.cs
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Configuration;
using System.Data.SqlClient;
/// <summary>
/// Summary description for Class1
/// </summary>
public class Class1
{
public SqlConnection con;
Public void show()
{
con = new SqlConnection(ConfigurationManager.ConnectionStrings["ABC"].ConnectionString);
con.Open();
}
}
Step 2
Coding | Default Page
Now we need to code in the default page, you can find this page in your website named:
Default.aspx.cs
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Configuration;
using System.Data.SqlClient;
public partial class _Default : System.Web.UI.Page
{
Class1 o = new Class1();
protected void Page_Load(object sender, EventArgs e)
{
o.show();
}
protected void Button1_Click(object sender, EventArgs e)
{
SqlCommand cmd = new SqlCommand("insert into Reg values('" + TextBox1.Text + "','" + TextBox2.Text + "')", o.con);
cmd.ExecuteNonQuery();
Response.Redirect("Default2.aspx");
}
}