Inserting Data Into Database in ASP.Net

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");

    }

}