SqlParameter Class
Assembly: System.Data (in system.data.dll)
[TypeConverterAttribute(typeof(SqlParameterConverter))] public sealed class SqlParameter : DbParameter, IDbDataParameter, IDataParameter, ICloneable
/** @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 void 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); }
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.