The System.Data.SqlClient SqlParameter class is used in C# to represent a parameter within an SQL statement or stored procedure. It is a part of the System.Data.SqlClient namespace in the .NET Framework.
Example 1: Setting a parameter value
SqlParameter myParam = new SqlParameter("@myParam", SqlDbType.NVarChar); myParam.Value = "example value";
In this example, we create a new SqlParameter object with the parameter name "@myParam" and set its data type to SqlDbType.NVarChar. We then set the value of the parameter to "example value".
Example 2: Specifying a parameter direction
SqlParameter myParam = new SqlParameter("@myParam", SqlDbType.NVarChar); myParam.Direction = ParameterDirection.InputOutput;
In this example, we create a new SqlParameter object with the parameter name "@myParam" and set its data type to SqlDbType.NVarChar. We then set the parameter direction to InputOutput, indicating that the parameter can be both input and output.
These code examples use the System.Data.SqlClient namespace which is part of the .NET framework for working with Microsoft SQL Server.
C# (CSharp) System.Data.SqlClient SqlParameter - 60 examples found. These are the top rated real world C# (CSharp) examples of System.Data.SqlClient.SqlParameter extracted from open source projects. You can rate examples to help us improve the quality of examples.