Passing parameter to stored procedure in C#

by

you can try this code :

bool result=false;
SqlCommand scCommand = new SqlCommand("usp_CheckEmailMobile", sqlCon);
scCommand.CommandType = CommandType.StoredProcedure;
scCommand.Parameters.Add("@Name", SqlDbType.VarChar, 50).Value = txtName.Text;
scCommand.Parameters.Add("@Email", SqlDbType.NVarChar, 50).Value = txtEmailAddress.Text;
scCommand.Parameters.Add("@Password ", SqlDbType.NVarChar, 50).Value = txtPassword.Text;
scCommand.Parameters.Add("@CountryCode", SqlDbType.VarChar.50).Value =ddlCountryCode.SelectedText;
scCommand.Parameters.Add("@Mobile", SqlDbType.NVarChar, 50).Value = txtMobileNumber.Text;
scCommand.Parameters.Add("@Result ", SqlDbType.Bit).Direction = ParameterDirection.Output;
try
{
    if (scCommand.Connection.State == ConnectionState.Closed)
    {
        scCommand.Connection.Open();
    }
    scCommand.ExecuteNonQuery();
    result = Convert.ToBoolean(scCommand.Parameters["@Result"].Value);


}
catch (Exception)
{

}
finally
{                
    scCommand.Connection.Close();
    Response.Write(result); 
}

More Related Contents:

  1. An unhandled exception of type ‘System.InvalidOperationException’ occurred in System.Data.dll?
  2. How to pass an array into a SQL Server stored procedure
  3. How to execute a stored procedure within C# program
  4. How to pass table value parameters to stored procedure from .net code
  5. How to call Stored Procedure in Entity Framework 6 (Code-First)?
  6. What are the pros and cons to keeping SQL in Stored Procs versus Code [closed]
  7. Call a stored procedure with parameter in c#
  8. Calling stored procedure with return value
  9. Capture Stored Procedure print output in .NET
  10. Entity Framework Stored Procedure Table Value Parameter
  11. Using stored procedure output parameters in C#
  12. Getting data from stored procedure with Entity Framework
  13. C# SQL Server – Passing a list to a stored procedure
  14. Difference between Parameters.Add(string, object) and Parameters.AddWithValue
  15. Get return value from stored procedure
  16. Does Entity Framework Code First support stored procedures?
  17. Passing List to SQL Stored Procedure
  18. Adding stored procedures complex types in Entity Framework
  19. Calling Oracle stored procedure from C#?
  20. Using DateTime in a SqlParameter for Stored Procedure, format error
  21. Entity Framework – stored procedure return value
  22. Stored procedure return into DataSet in C# .Net
  23. How to pass XML from C# to a stored procedure in SQL Server 2008?
  24. Asking for legitimate example of calling stored procedure C#: MYSQL
  25. What is passing parameters to SQL and why do I need it?
  26. Add WHERE clauses to SQL dynamically / programmatically
  27. How to pass a null variable to a SQL Stored Procedure from C#.net code
  28. How to call Stored Procedures with EntityFramework?
  29. How do I return XML from a Stored Procedure?
  30. How to use a DataAdapter with stored procedure and parameter

Leave a Comment