Database did not record data inserted. No errors shown. 3 tier design in microsoft visual studios 2010

Question

This is my INSERT statement into the Database. The Database did not record any data after i clicked the button. No errors are shown. 

        sql = new StringBuilder();
        sql.AppendLine("INSERT INTO PaymentNANO (PaymentID,PaymentType, TotalAmount, DateTime1)");
        sql.AppendLine("VALUES (@PaymentID, @PaymentType, @TotalAmount, @DateTime1)");
        //(PaymentType, TotalAmount, DateTime1)
        try
        {
            conn.Open();
            sqlCmd = new SqlCommand(sql.ToString(), conn);
            sqlCmd.Parameters.AddWithValue("@PaymentID", PaymentID);
            sqlCmd.Parameters.AddWithValue("@PaymentType", PaymentType);
            sqlCmd.Parameters.AddWithValue("@TotalAmount", TotalAmount);
            sqlCmd.Parameters.AddWithValue("@DateTime1", DateTime1);
            result = sqlCmd.ExecuteNonQuery();
        }
        catch (Exception ex)
        {
            errMsg = ex.Message;
        }
        finally
        {
            conn.Close();
        }

        return result;
    }

Any idea why?

Answer 1

Please try to refresh the table  in the Management Studio.

---

mysorian

Answer 2

Hello,

Halve you debug your code to see if it reaches the ExecuteNonQuery method? What to "result" return for a value, -1, 0 or 1?

---

Olaf Helper

Blog Xing