ExecuteNonQuery returns 1 , Database wont Update

Itzik S

hello i am creating a Windows Application C# 3.5 when i executeing function to insert into SQL Epxress it returns 1 on the Rows Effect but checking the Database Data nothing is inserted. public int ExectueNonQuery(string command) { int Results = -1; try { connection = new SqlConnection(ConnectionString); connection.Open(); scommand = new SqlCommand(command, connection); Results = scommand.ExecuteNonQuery(); } finally { scommand.Dispose(); if (connection != null) connection.Close(); } return Results; }

7 Replies

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

Itzik S17y ago
Accepted answer
Problem solved it was DB Location.
Itzik S17y ago
yeah me too i think its cause i got OS x64 bit.. not sure though
Cory17y ago
Yes! Finally. Thanks so much, I have been struggling with this problem for quite a while.
Itzik S17y ago
add the DB to the Data Connections Explorer. by Add Connection point to ur MDF file. update the Connectionstring in app.config to point to the Database.. if ur C:\Test\ProjectInfo.mdf then Connectionstring Should be connectionString="Data Source=.\SQLEXPRESS;AttachDbFilename=C:\Test\ProjectInfo.mdf;Integrated Security=True;User Instance=True"
Cory17y ago
Hi, many thanks for the quick response. I believe you have correctly identified my problem.

So, I have stored my database at C:\Test\ProjectInfo.mdf -- what other steps will I need to take?

Would my connection string simply be the file path? Do I have to add that localized database (Project --> Add Existing Item...) into my project from within visual studio? I have tried a few different things and keep getting an error when I attempt to open a connection to that localized database.
Itzik S17y ago
when u Run or Debug it copies the DB in to the new location and insert/Update/Select from there but when u do Open Table Data its points to root dirctory and not the DataDirectory. the solution was : for debuging\Testing just put the DB in a static location for example C:\DB\name.MDF and point the app.config there i hope it helps u
Cory17y ago
Hello, I am having a similar issue. I run an UPDATE sql command using ExecuteNonQuery(), and no error messages appear. However, when I return to visual studio, right-click on the relevant table and select "Show Table Data", the new data has not been inserted.

You said the problem was with your "DB Location"; could you please elaborate? What exactly was the problem with your DB location? Did you need to alter the connection string, or a database property, or anything else?

In short, what problem did you find with your DB Location, and how did you correct the issue? Thanks!