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