Insert into C# with SQLCommand

by

Try confirm the data type (SqlDbType) for each parameter in the database and do it this way;

 using(SqlConnection connection = new SqlConnection(ConfigurationManager.ConnectionStrings["connSpionshopString"].ConnectionString))
 {
            connection.Open();
            string sql =  "INSERT INTO klant(klant_id,naam,voornaam) VALUES(@param1,@param2,@param3)";
            using(SqlCommand cmd = new SqlCommand(sql,connection)) 
            {
                  cmd.Parameters.Add("@param1", SqlDbType.Int).Value = klantId;  
                  cmd.Parameters.Add("@param2", SqlDbType.VarChar, 50).Value = klantNaam;
                  cmd.Parameters.Add("@param3", SqlDbType.VarChar, 50).Value = klantVoornaam;
                  cmd.CommandType = CommandType.Text;
                  cmd.ExecuteNonQuery(); 
            }
 }

More Related Contents:

  1. When should “SqlDbType” and “size” be used when adding SqlCommand Parameters?
  2. ExecuteReader requires an open and available Connection. The connection’s current state is Connecting
  3. MetadataException: Unable to load the specified metadata resource
  4. Get output parameter value in ADO.NET
  5. Under what circumstances is an SqlConnection automatically enlisted in an ambient TransactionScope Transaction?
  6. Is it necessary to manually close and dispose of SqlDataReader?
  7. Populate data table from data reader
  8. When using Trusted_Connection=true and SQL Server authentication, will this affect performance?
  9. Difference with Parameters.Add and Parameters.AddWithValue
  10. SqlConnection SqlCommand SqlDataReader IDisposable
  11. Exception when AddWithValue parameter is NULL
  12. Calling Oracle stored procedure from C#?
  13. Is SqlCommand.Dispose() required if associated SqlConnection will be disposed?
  14. How to run multiple SQL commands in a single SQL connection?
  15. MultipleActiveResultSets=True or multiple connections?
  16. How to pass a table-value parameter
  17. How DataReader works?
  18. How to keep single SQL Server connection instance open for multiple request in C#?
  19. DataTable equivalent in Java [duplicate]
  20. How do I re-write a SQL query as a parameterized query?
  21. How do I translate a List into a SqlParameter for a Sql In statement? [duplicate]
  22. Check if a SQL table exists
  23. What is the difference between dataview and datatable?
  24. Replacing a DataReader with a DataTable
  25. Reading a date using DataReader
  26. What ‘length’ parameter should I pass to SqlDataReader.GetBytes()
  27. How do I connect to a SQL database from C#?
  28. .net connection pooling
  29. How can I Pass a Table Name to SqlCommand?
  30. Do we have transactions in MS-Access?

Leave a Comment