SqlParameter Class
Assembly: System.Data (in system.data.dll)
'Declaration Public NotInheritable Class SqlParameter Inherits DbParameter Implements IDbDataParameter, IDataParameter, ICloneable 'Usage Dim instance As SqlParameter
public final class SqlParameter extends DbParameter implements IDbDataParameter, IDataParameter, ICloneable
public final class SqlParameter extends DbParameter implements IDbDataParameter, IDataParameter, ICloneable
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.
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 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 .NET Framework does not support all versions of every platform. For a list of the supported versions, see System Requirements.