C# MDF database is not inserting data even if success message is displayed

Question

I need to insert data when user clicks. But, my code isn't doing it. Even though it displays the data inserted message, the data is not inserted. How can I find the mistake?

private void bunifuFlatButton2_Click(object sender, EventArgs e)
    {

        SqlConnection con = new SqlConnection(@"Data Source=(LocalDB)\MSSQLLocalDB;AttachDbFilename=**F:\Blackhat\Blackhat\Blackhat.mdf**;Integrated Security=True");
        try
         {
            con.Open();
            SqlCommand cmd = new SqlCommand("Insert Into Clients(name) VALUES ('"+clientname.Text+"')", con);
            cmd.ExecuteNonQuery();
            MessageBox.Show("Success "+clientname.Text);
             con.Close();
         }
         catch (SqlException ex)
         {
             MessageBox.Show("Failed"+ex);
         }
    }

Read about SQLParameters or if you have any exception showing up, show us the contents of it. — mrogal.ski, Jul 20 '17 at 09:14
Check if you have Copy to output directory set to Always between the properties of the MDF file listed in your project — Steve, Jul 20 '17 at 14:31

score 0 · Accepted Answer · answered Jul 20 '17 at 09:47

Since there are no exception, the issue would be like, you are writing it to a wrong file in a wrong location or something of that sort.

If it fails to write, there will be an exception and it goes to the catch block.

So we can expect that there are nothing wrong in the c# code.

If you are checking the entries using SQL server management studio, you need try querying the database. The edit 200 rows option needs a database refresh and edit again after closing the existing edit tab. else the vales do not appear to be changing.

Hope this helps. If the issue is something else, please mention in the comments.

C# MDF database is not inserting data even if success message is displayed

1 Answers1