error in insert value into table of database

Question

1.00/5 (2 votes)

See more:

i try to insert a value into table called student in sqlserver but i get error in line cmd.ExecuteNonQuery;

C#

public partial class additem : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        
    }
    protected void TextBox1_TextChanged(object sender, EventArgs e)
    {

    }
    protected void addButton_Click(object sender, EventArgs e)
    {
       SqlConnection cn = new SqlConnection(@"Server=.\SQLEXPRESS; DataBase=first; Integrated Security=true;");
       SqlCommand cmd;
        cmd = new SqlCommand("Insert into student (id) values ("+ idTextBox.Text +")", cn);
        try
        {
            cn.Open();
            cmd.ExecuteNonQuery;
            resultLabel.Text = "added successfully";
        }
        catch (SqlException ex)
        {
            resultLabel.Text = ("error" + ex.Message);
        }
        finally
        {
            cn.Close();
        }
    }

Posted 14-Jun-14 10:07am

2012medo

Add a Solution

Comments

MayurDighe 14-Jun-14 17:46pm

Always Try to Debug the program using Built-in facilities (e.g. The Menu Bar -> Debug Menu).

Soumitra Mithu 14-Jun-14 23:39pm

what is the error it says??

8 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

2012medo · Answer 1 · 2014-06-14T10:35:00

Solution 1

i found the error

it just should be
cmd.ExecuteNonQuery();

Posted 14-Jun-14 10:35am

2012medo

PrakashCs.net · Answer 2 · 2014-06-17T20:58:00

you have done 2 mistake

1. SqlCommand values does not have '
2. Eecute non query should like this cmd.ExecuteNonQuery()

C#

protected void addButton_Click(object sender, EventArgs e)
    {
       SqlConnection cn = new SqlConnection(@"Server=.\SQLEXPRESS; DataBase=first; Integrated Security=true;");
       SqlCommand cmd;
        cmd = new SqlCommand("Insert into student (id) values ('"+ idTextBox.Text +"')", cn);
        try
        {
            cn.Open();
            cmd.ExecuteNonQuery();
            resultLabel.Text = "added successfully";
        }
        catch (SqlException ex)
        {
            resultLabel.Text = ("error" + ex.Message);
        }
        finally
        {
            cn.Close();
        }
    }

Peter Leow · Answer 3 · 2014-06-18T06:26:00

Solution 8

Use parameterized query, check this out[^]

Posted 18-Jun-14 6:26am

Peter Leow

Member 10884288 · Answer 4 · 2014-06-14T15:24:00

Solution 2

USE CODE AS BELOW

protected void addButton_Click(object sender, EventArgs e)
{
SqlConnection cn = new SqlConnection(@"Server=.\SQLEXPRESS; DataBase=first; Integrated Security=true;");
Cn.open();
SqlCommand cmd;
cmd = new SqlCommand("Insert into student (id) values (‘"+ idTextBox.Text +"’)", cn);

cmd.ExecuteNonQuery;

resultLabel.Text = "added successfully";
cn.close();

}

Posted 14-Jun-14 15:24pm

Member 10884288

Comments

[no name] 14-Jun-14 21:34pm

If you had been reading, the OP solved his own issue. And like the OPs original code, your code will not compile either.

ZurdoDev 18-Jun-14 7:54am

This is open to SQL injection. Not a good suggestion.

Alexander andri · Answer 5 · 2014-06-17T16:55:00

Try this.

From:

C#

SqlCommand cmd;
cmd = new SqlCommand("Insert into student (id) values ("+ idTextBox.Text +")", cn);

Change to :

C#

SqlCommand cmd = new SqlCommand("Insert into student (id) values ("+ idTextBox.Text +")", cn);

From

C#

try
        {
            cn.Open();
            cmd.ExecuteNonQuery;
            resultLabel.Text = "added successfully";
        }

Change to:

C#

try
        {
            cmd.cn.Open();
            cmd.ExecuteNonQuery;
            resultLabel.Text = "added successfully";
        }

Hope can help.

AshishvermaMCA · Answer 6 · 2014-06-18T01:48:00

Solution 5

As seen your above code -

First you check that id column of student is primary key or identity or not. If id column is primary key then you can not insert the record.

If id column is not p.k or identity then you post the exact error.

Posted 18-Jun-14 1:48am

AshishvermaMCA

Mandip Grewal · Answer 7 · 2014-06-18T02:08:00

Solution 6

ExecuteNonQuery is a function. You can't use it like property. Please apply paranthesis () just after the ExecuteNonQuery to execute it as function as shown below

C#

cmd.ExecuteNonQuery();

Hope, this'll help you.

Posted 18-Jun-14 2:08am

Mandip Grewal

priya dharshan · Answer 8 · 2014-06-18T05:50:00

Solution 7

Use cmd.ExecuteNonQuery(); instead of cmd.ExecuteNonQuery

Posted 18-Jun-14 5:50am

priya dharshan