Unable to insert Value into database

•

What is DaniWeb IT Discussion Community?

You're currently browsing the MySQL section within the Web Development category of DaniWeb, a massive community of 427,935 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 2,936 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.

Join our community!

Please support our MySQL advertiser: Programming Forums

Thread Tools Display Modes

Views: 1051 | Replies: 5

•

Join Date: Jun 2008

Posts: 3

Reputation: mridatrix is an unknown quantity at this point

Rep Power: 0

Solved Threads: 0

mridatrix

Offline

Newbie Poster

Unable to insert Value into database

Jul 8th, 2008

i was just doing a simple thing in C#, just trying to put the values feeded in the text boxes in sql database. i am giving the code below the code executed perfectly but when i went to look into the table data there was no data inserted...... pls HELP...!!!

Help with Code Tags

(Toggle Plain Text)

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using System.Data.SqlClient;
using System.Data.Sql;

namespace txtbox
{
    public partial class Form1 : Form
    {
        public Form1()
        {
            InitializeComponent();
        }

        private void button1_Click(object sender, EventArgs e)
        {
            SqlConnection cn=new SqlConnection("Data Source=.\\SQLEXPRESS;AttachDbFilename=|DataDirectory|\\Details.mdf;Integrated Security=True;User Instance=True");
            string sql = " INSERT into employee(fname, mname, lname) VALUES (@fname, @mname,@lname)";
            SqlCommand cmd = new SqlCommand(sql, cn);
            cmd.Parameters.Add(new SqlParameter("@fname", SqlDbType.NVarChar,50));
            cmd.Parameters.Add(new SqlParameter("@mname", SqlDbType.NVarChar,50));
            cmd.Parameters.Add(new SqlParameter("@lname", SqlDbType.NVarChar,50));

            cmd.Parameters[0].Value = textBox1.Text;
            cmd.Parameters[1].Value = textBox2.Text;
            cmd.Parameters[2].Value = textBox3.Text;
            cn.Open();
            cmd.ExecuteNonQuery();
            MessageBox.Show("inserted successfully");
        }
    }
}

at the end i get the message in the message box "inserted successfully" but there is no value inserted in the table....

•

Join Date: Dec 2007

Posts: 114

Reputation: mwasif is an unknown quantity at this point

Rep Power: 1

Solved Threads: 14

mwasif

Offline

Junior Poster

Re: Unable to insert Value into database

Jul 8th, 2008

String values must be enclosed with single quotes e.g.

Help with Code Tags

(Toggle Plain Text)

INSERT into employee(fname, mname, lname) VALUES ('name', 'mname','name')

You may try similar to this

Help with Code Tags

(Toggle Plain Text)

string sql = " INSERT into employee(fname, mname, lname) VALUES ('@fname', '@mname','@lname')";

•

Join Date: Jun 2008

Posts: 3

Reputation: mridatrix is an unknown quantity at this point

Rep Power: 0

Solved Threads: 0

mridatrix

Offline

Newbie Poster

Re: Unable to insert Value into database

Aug 6th, 2008

•

Originally Posted by mwasif

String values must be enclosed with single quotes e.g.
Help with Code Tags

(Toggle Plain Text)
INSERT into employee(fname, mname, lname) VALUES ('name', 'mname','name')
INSERT into employee(fname, mname, lname) VALUES ('name', 'mname','name')
You may try similar to this
Help with Code Tags

(Toggle Plain Text)
string sql = " INSERT into employee(fname, mname, lname) VALUES ('@fname', '@mname','@lname')";
string sql = " INSERT into employee(fname, mname, lname) VALUES ('@fname', '@mname','@lname')";

Still not able to insert values into database table ....
whts the problem i cant figure it out ....
kindly help

•

Join Date: Jul 2008

Location: Sweet India

Posts: 849

Reputation: Shanti Chepuru is on a distinguished road

Rep Power: 2

Solved Threads: 74

Shanti Chepuru Shanti Chepuru is offline

Offline

Practically a Posting Shark

Re: Unable to insert Value into database

Aug 8th, 2008

please once try this:

Help with Code Tags

(Toggle Plain Text)

 string sql = " INSERT into `employee`(`fname`, `mname`,` lname`) VALUES (@fname, @mname,@lname)";

Be intelligent, But Don't try to cheat.. Be innocent But Don't get cheated..

•

Join Date: Jun 2008

Posts: 3

Reputation: mridatrix is an unknown quantity at this point

Rep Power: 0

Solved Threads: 0

mridatrix

Offline

Newbie Poster

Re: Unable to insert Value into database

Aug 9th, 2008

•

Originally Posted by Shanti Chepuru

please once try this:
Help with Code Tags

(Toggle Plain Text)
 string sql = " INSERT into `employee`(`fname`, `mname`,` lname`) VALUES (@fname, @mname,@lname)";
string sql = " INSERT into `employee`(`fname`, `mname`,` lname`) VALUES (@fname, @mname,@lname)";

i knew this wont work but gave it a try ..... it still does not solves the problem

•

Join Date: Dec 2004

Location: London or Slovakia

Posts: 2,467

Reputation: peter_budo is a jewel in the rough

Rep Power: 11

Solved Threads: 296

peter_budo peter_budo is offline

Offline

Code tags enforcer

Re: Unable to insert Value into database

Aug 10th, 2008

@mridatrix - your coding is wrong. Database connectivity in any programming language is always associated with try & catch block often accompanied by final . Something similar to this example

 Help with Code Tags 
 c# Syntax (Toggle Plain Text) 
try
{
     conn.Open();
     cmd.ExecuteNonQuery();
}
catch (SqlException ex)
{
     errorMessage();
}
finally
{
     conn.Close();
     // Just simple notification
     DialogResult result =
         MessageBox.Show("New book added to database", "Database Message",
          MessageBoxButtons.OK, MessageBoxIcon.Information, 0, 0);
}
try
{
     conn.Open();
     cmd.ExecuteNonQuery();
}
catch (SqlException ex)
{
     errorMessage();
}
finally
{
     conn.Close();
     // Just simple notification
     DialogResult result =
         MessageBox.Show("New book added to database", "Database Message",
          MessageBoxButtons.OK, MessageBoxIcon.Information, 0, 0);
}

Learn to see in another's calamity the ills which you should avoid.
Publilius Syrus
(~100 BC)
If we helped you to solve your problem, answered your question please mark your post as SOLVED.