Represents a parameter to a
PgSqlCommand, and optionally, its mapping to
System.Data.DataSet columns.
The following example creates multiple instances of
PgSqlParameter through the
PgSqlParameterCollection within the
PgSqlDataAdapter. These parameters are used to select data from PostgreSQL and place the data in the
System.Data.DataSet. This example assumes that a
System.Data.DataSet and a
PgSqlDataAdapter have already been created with the appropriate schema, commands, and connection.
public void AddPgSqlParameters()
{
// ...
// create myDataSet and myDataAdapter
// ...
myDataAdapter.SelectCommand.Parameters.Add("DName", PgSqlType.VarChar, 15).Value = "DEVELOPMENT";
myDataAdapter.SelectCommand.Parameters.Add("DeptNo", PgSqlType.Int).Value = 50;
myDataAdapter.Fill(myDataSet);
}
Public Sub AddPgSqlParameters()
' ...
' create myDataSet and myDataAdapter
' ...
myDataAdapter.SelectCommand.Parameters.Add("DName", PgSqlType.VarChar, 15).Value = "DEVELOPMENT"
myDataAdapter.SelectCommand.Parameters.Add("DeptNo", PgSqlType.Int).Value = 50
myDataAdapter.Fill(myDataSet)
End Sub