SqlParameter Class
Assembly: System.Data (in system.data.dll)
'Declaration <TypeConverterAttribute(GetType(SqlParameterConverter))> _ Public NotInheritable Class SqlParameter Inherits DbParameter Implements IDbDataParameter, IDataParameter, ICloneable 'Usage Dim instance As SqlParameter
/** @attribute TypeConverterAttribute(System.Data.SqlClient.SqlParameter+SqlParameterConverter) */ public final class SqlParameter extends DbParameter implements IDbDataParameter, IDataParameter, ICloneable
TypeConverterAttribute(System.Data.SqlClient.SqlParameter+SqlParameterConverter) public final class SqlParameter extends DbParameter implements IDbDataParameter, IDataParameter, ICloneable
Not applicable.
The following example creates multiple instances of SqlParameter through the SqlParameterCollection collection within the SqlDataAdapter. These parameters are used to select data from the data source and put the data in the DataSet. This example assumes that a DataSet and a SqlDataAdapter have already been created by using the appropriate schema, commands, and connection. For more information and additional examples on using parameters with SQL Server, see Connecting and Retrieving Data in ADO.NET and Modifying Data in ADO.NET.
Public Sub AddSqlParameters() ' ... ' create categoriesDataSet and categoriesAdapter ' ... categoriesAdapter.SelectCommand.Parameters.Add( _ "@CategoryName", SqlDbType.VarChar, 80).Value = "toasters" categoriesAdapter.SelectCommand.Parameters.Add( _ "@SerialNum", SqlDbType.Int).Value = 239 categoriesAdapter.Fill(categoriesDataSet) End Sub
System.MarshalByRefObject
System.Data.Common.DbParameter
System.Data.SqlClient.SqlParameter
Windows 98, Windows Server 2000 SP4, Windows CE, Windows Millennium Edition, Windows Mobile for Pocket PC, Windows Mobile for Smartphone, Windows Server 2003, Windows XP Media Center Edition, Windows XP Professional x64 Edition, Windows XP SP2, Windows XP Starter Edition
The Microsoft .NET Framework 3.0 is supported on Windows Vista, Microsoft Windows XP SP2, and Windows Server 2003 SP1.