Insert row into database from C# form

Question

String ConString =  @"DataSource=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\BizContact.mdf;Integrated Security=True;User Instance=True";

SqlConnection cn = new SqlConnection(ConString);
try
{
   cn.Open();
   MessageBox.Show("connect");
}
catch (Exception)
{
   MessageBox.Show("Did not connect");
}       

SqlCommand cmd = new SqlCommand("insert tableNote values (@UserName,@Note)",cn);
cmd.Parameters.AddWithValue("@UserName", textBox1.Text);
cmd.Parameters.AddWithValue("@Note", textBox2.Text);

try
{
   int res = cmd.ExecuteNonQuery();

   if (res > 0)
   {
      MessageBox.Show("insert");
   }
}
catch (Exception ex)
{
   MessageBox.Show(ex.Message);
}
finally
{
   cn.Close();
}

I am trying to add new row to the database. The above code is correct with no error and it display the try statement but does not insert row into the database. Any idea to solve it.

try printing value of res. It should be 1 because it gives the number of rows inserted. — Nikhil Agrawal
– Nikhil Agrawal, Commented Apr 29, 2012 at 7:10
Look in your project directory, there may be multiple copies of BizContact.mdf Check all of them for your inserted record. — gideon
– gideon, Commented Apr 29, 2012 at 7:15
Try to use SQL Profiler and see the query generated and try to run it in SSMS . — praveen
– praveen, Commented Apr 29, 2012 at 7:19

aifarfa · Accepted Answer · 2012-04-29 08:29:46Z

4

try full T-SQL statement

"INSERT INTO table_name (userColumn, noteColumn) VALUES (@UserName, @Note)"

also dispose SqlConnection via using state

using(SqlConnection  cn = new SqlConnection(ConString))
{
  //....
}

edited Apr 29, 2012 at 8:29

answered Apr 29, 2012 at 7:17

aifarfa

3,9392 gold badges25 silver badges35 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

juergen d · Accepted Answer · 2012-04-29 07:16:30Z

3

Your insert statement is wrong (missing into). Do either:

insert into tableNote select @UserName,@Note

or

insert into tableNote (column_name1, column_name2) values (@UserName,@Note)

answered Apr 29, 2012 at 7:16

juergen d

205k40 gold badges303 silver badges377 bronze badges

Comments

robrich · Accepted Answer · 2012-04-29 07:16:51Z

0

Open up Sql Profiler and watch it execute the command, then try replaying that command into Sql Management Studio. More than likely, it'll show you that the query is ever so slightly malformed such that it happily does nothing successfully.

answered Apr 29, 2012 at 7:16

robrich

13.3k7 gold badges39 silver badges63 bronze badges

Collectives™ on Stack Overflow

Insert row into database from C# form

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related