Insert Data into SQL DataBase

Mohammad Rashed Obaidat

Dear all,

I try to insert data into my Database but when I click the button nothing happen I tried to use select statement instead of insert statement and it works well, but when I try ti update or insert data nothing happens, could anybody help me with that?

This is the code:

SqlConnection con = new SqlConnection();
SqlCommand cmd = new SqlCommand();

    con.ConnectionString = @"Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\nobel.mdf;Integrated Security=True;User Instance=True";
    con.Open();
    cmd.CommandText = "INSERT INTO test VALUES (@amount, @description)";
                cmd.Parameters.AddWithValue("@amount", Convert.ToInt64(txt_amount.Text));
                cmd.Parameters.AddWithValue("@description", rtxt_description.Text);
                cmd.Connection = con;
                cmd.ExecuteNonQuery();
                con.Close();

8 Replies

Know the answer? Post it — somebody with the same question will find it here.

Mohammad Rashed Obaidat14y ago
I tried every thing you said, but nothing is working. I'm afraid that the problem might be from the visual studio itself
Zuber Kazi14y ago
try this
sqlcommand cmd=new sqlcommand("insert into test values('"+Convert.ToInt64(txt_amount.Text)+"','"+rtxt_description.Text+"')",con);
cmd.ExecuteNonQuery();
Vulpes14y ago
If you change:

cmd.ExecuteNonQuery();

to:

int rowsAffected = cmd.ExecuteNonQuery();

and then either put a breakpoint on that line or do a MessageBox.Show on rowsAffected, do you get a non-zero value?
Mohammad Rashed Obaidat14y ago
Dear Satyapriya Nayak, the code you gave me and the code i wrote can work on a website, but the problem is I'm trying to insert the data on a Windows Application Form and I can't figure why it doesn't insert any data
Satyapriya Nayak14y ago
Hi Mohammad,

Try this...

<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="WebForm1.aspx.cs" Inherits="Register.WebForm1" %>

    Untitled Page

















using System;
using System.Collections;
using System.Configuration;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
using System.Data.SqlClient;
namespace Register_using_param
{
    public partial class WebForm1 : System.Web.UI.Page
    {
        string strConnString = ConfigurationManager.ConnectionStrings["MyConsString"].ConnectionString;
        string str;
        SqlCommand cmd;


        protected void Register_Click(object sender, EventArgs e)
        {
            SqlConnection con = new SqlConnection(strConnString);
            con.Open();
            str="INSERT INTO test VALUES (@amount, @description)";
            cmd = new SqlCommand(str,con);
            cmd.CommandType = CommandType.Text;
            cmd.Parameters.AddWithValue("@amount", Convert.ToInt64(txt_amount.Text));
            cmd.Parameters.AddWithValue("@description", rtxt_description.Text);
            cmd.Connection = con;
            cmd.ExecuteNonQuery();
            con.Close();
            Response.Write("Records Inserted");

        }
    }
}

Thanks
Mohammad Rashed Obaidat14y ago
Krishna Garad, I tried what you said but nothing happened the data is not inserted on the Database, but thank you anyway.

Vulpes, you have to write the column names if you want to insert data into specific fields on the Database, and I tried it and it didn't help, but thank you anyway.
Vulpes14y ago
You're lacking the names of the columns into which to insert the corresponding values in the database table:

cmd.CommandText = "INSERT INTO test (amount, description) VALUES (@amount, @description)";
Krishna Garad14y ago
try this
SqlConnection con = new SqlConnection(@"Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\nobel.mdf;Integrated Security=True;User Instance=True";);
SqlCommand cmd = new SqlCommand( "INSERT INTO test VALUES (@amount, @description)",con);

       con.Open();

                cmd.Parameters.AddWithValue("@amount", Convert.ToInt64(txt_amount.Text));
                cmd.Parameters.AddWithValue("@description", rtxt_description.Text);
                cmd.Connection = con;
                cmd.ExecuteNonQuery();
                con.Close();