Call a stored procedure with parameter in c#

by

It’s pretty much the same as running a query. In your original code you are creating a command object, putting it in the cmd variable, and never use it. Here, however, you will use that instead of da.InsertCommand.

Also, use a using for all disposable objects, so that you are sure that they are disposed properly:

private void button1_Click(object sender, EventArgs e) {
  using (SqlConnection con = new SqlConnection(dc.Con)) {
    using (SqlCommand cmd = new SqlCommand("sp_Add_contact", con)) {
      cmd.CommandType = CommandType.StoredProcedure;

      cmd.Parameters.Add("@FirstName", SqlDbType.VarChar).Value = txtFirstName.Text;
      cmd.Parameters.Add("@LastName", SqlDbType.VarChar).Value = txtLastName.Text;

      con.Open();
      cmd.ExecuteNonQuery();
    }
  }
}

More Related Contents:

  1. Procedure or function xxxxx has too many arguments specified [duplicate]
  2. Insert 2 million rows into SQL Server quickly
  3. Calling stored procedure with return value
  4. Getting data from stored procedure with Entity Framework
  5. Connection timeout for SQL server
  6. What is passing parameters to SQL and why do I need it?
  7. Add WHERE clauses to SQL dynamically / programmatically
  8. Fastest method for SQL Server inserts, updates, selects
  9. How to make an algorithm to get all column names from across tables that relations with their primary key in SQL Server and C#?
  10. How to pass an array into a SQL Server stored procedure
  11. How to execute a stored procedure within C# program
  12. SQL Network Interfaces, error: 50 – Local Database Runtime error occurred. Cannot create an automatic instance
  13. Cannot open database “test” requested by the login. The login failed. Login failed for user ‘xyz\ASPNET’
  14. SQL command INSERT is working but the data not appear in table
  15. Return value from SQL Server Insert command using c#
  16. How to pass sqlparameter to IN()? [duplicate]
  17. How do I return multiple result sets with SqlCommand?
  18. Avoiding SQL injection without parameters
  19. Using DateTime in a SqlParameter for Stored Procedure, format error
  20. MultipleActiveResultSets=True or multiple connections?
  21. Creating a SQL Server table from a C# datatable
  22. SQL: Update a row and returning a column value with 1 query
  23. How DataReader works?
  24. Stored procedure return into DataSet in C# .Net
  25. Retrieve image from database in asp.net
  26. How to pass a null variable to a SQL Stored Procedure from C#.net code
  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. Passing array to a SQL Server Stored Procedure

Leave a Comment