How to give ADO.NET Parameters

by

Should use something like the following:

SqlCommand cmd = new SqlCommand("INSERT INTO Product_table Values(@Product_Name, @Product_Price, @Product_Profit, @p)", connect);
cmd.Parameters.Add("@Product_Name", SqlDbType.NVarChar, ProductNameSizeHere).Value = txtProductName.Text;
cmd.Parameters.Add("@Product_Price", SqlDbType.Int).Value = txtProductPrice.Text;
cmd.Parameters.Add("@Product_Profit", SqlDbType.Int).Value = txtProductProfit.Text;
cmd.Parameters.Add("@p", SqlDbType.NVarChar, PSizeHere).Value = txtP.Text;
cmd.ExecuteNonQuery();

Assuming @p parameter is some NVarChar.

Better avoid using AddWithValue, see why here:
https://blogs.msmvps.com/jcoehoorn/blog/2014/05/12/can-we-stop-using-addwithvalue-already/

Also at INSERT SQL statement better provide names of the values (as defined in the database) before the values themselves, as shown at https://www.w3schools.com/sql/sql_insert.asp

More Related Contents:

  1. SqlBulkCopy from a List
  2. ExecuteNonQuery returning -1 when using sql COUNT despite the query string
  3. Add WHERE clauses to SQL dynamically / programmatically
  4. Delete from two tables? [closed]
  5. How to use DbContext.Database.SqlQuery(sql, params) with stored procedure? EF Code First CTP5
  6. Pass table valued parameter using ADO.NET
  7. Insert entire DataTable into database at once instead of row by row?
  8. How do I return multiple result sets with SqlCommand?
  9. Getting return value from stored procedure in C#
  10. Is it necessary to manually close and dispose of SqlDataReader?
  11. SQL error: Incorrect syntax near the keyword ‘User’
  12. Passing List to SQL Stored Procedure
  13. Query extremely slow in code but fast in SSMS
  14. How to retrieve data from a SQL Server database in C#?
  15. How to run multiple SQL commands in a single SQL connection?
  16. Any way to SQLBulkCopy “insert or update if exists”?
  17. SQLException : String or binary data would be truncated
  18. Multi threading C# application with SQL Server database calls
  19. What’s the fastest way to bulk insert a lot of data in SQL Server (C# client)
  20. SQL: Update a row and returning a column value with 1 query
  21. How to keep single SQL Server connection instance open for multiple request in C#?
  22. How to use SqlCommand to CREATE DATABASE with parameterized db name?
  23. What size do you use for varchar(MAX) in your parameter declaration?
  24. How to insert data into SQL Server
  25. Query validation using C#
  26. Unable to connect to localDB in VS2012 – “A network-related or instance-specific error occurred while establishing a connection to SQL Server…”
  27. Why does the SqlParameter name/value constructor treat 0 as null?
  28. How do I connect to a SQL database from C#?
  29. Database Error: There is no row at position 0
  30. Is SqlConnection.Close() need inside a Using statement?

Leave a Comment