Insert data into a SQL Server database using ASP.NET is not working

Question

I wrote code to insert data into the database, after I click the insert button, nothing happens and there is no error. Please I need help.

If I click the insert button from the front end, it is supposed to populate the database.

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data.SqlClient;

namespace insertAdo
{
    public partial class TableInsert : System.Web.UI.Page
    {
        protected void Button1_Click(object sender, EventArgs e)
        {
            string connectionString;
            SqlConnection cnn;

            connectionString = @"Data Source=DESKTOP-5JPBK1L;Database=StudentDB; Integrated Security=SSPI";

            cnn = new SqlConnection(connectionString);

            cnn.Open();
            {
                SqlCommand command;
                SqlDataAdapter adapter = new SqlDataAdapter();
                String sql = "";

                sql = "INSERT INTO  student_table (Student_id, name, Email, Join_date) VALUES (102, 'Jaja Peter', '[email protected]', '09/30/2021')";

                command = new SqlCommand(sql, cnn);
                adapter.InsertCommand = new SqlCommand(sql, cnn);
                adapter.InsertCommand.ExecuteNonQuery();

                command.Dispose();
            }

            Response.Write("Insert successful");
            cnn.Close();
        }
    }
}

Were you able to debug your code? Response.Write("Insert Successful"); this line of code executes? — Chetan
– Chetan, Commented Apr 30, 2022 at 16:07
Why don't you do command.ExecuteNonQuery(). You don't need adapter. — Chetan
– Chetan, Commented Apr 30, 2022 at 16:08
You should use using instead of manually Disposing the command. — Chetan
– Chetan, Commented Apr 30, 2022 at 16:09
Could you add to the question the asp.net page markup where the button is defined? Did you set the correct binding to your click event to the code behind? — Steve
– Steve, Commented Apr 30, 2022 at 16:12

Anand Sowmithiran · Accepted Answer · 2022-04-30 16:57:22Z

First ensure that your front-end UI button's Click event is wired up , like below in your aspx page.

 <asp:Button id="Button1"
           Text="Click here for inserting..."
           OnClick="Button1_Click" 
           runat="server"/>

After that make the modification in your .cs code file as below.

    string connectionString = @"Data Source=DESKTOP-5JPBK1L;Database=StudentDB; Integrated Security=SSPI";

    string sql = "Insert into student_table(Student_id,name,Email,Join_date) values(102,'Jaja Peter','[email protected]','09/30/2021')";

    // create connection and command
    using(SqlConnection cn = new SqlConnection(connectionString))
    using(SqlCommand cmd = new SqlCommand(sql, cn))
    {
        // open connection, execute INSERT, close connection
        cn.Open();
        cmd.ExecuteNonQuery();
        cn.Close();
    }

Use of the using block ensures that your connection and command objects are disposed properly.

For learning, this way of hard coding the values is okay, but in real world scenario, you would need to use parameters, and use model class, not have the connecting string inside your code etc.

Collectives™ on Stack Overflow

Insert data into a SQL Server database using ASP.NET is not working

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related