IngresParameter Class Example
The following is an implementation of the IngresParameter class:
static string DemoParameterSSN(
string connstring, int intNumber, string strSSN)
{
IngresConnection conn = new IngresConnection(connstring);
string strName = null;
conn.Open();
IngresCommand cmd = new IngresCommand(
"select name from demo_personnel where number = ? and ssn = ?",
conn);
// add two parameters to the command's IngresParameterCollection
cmd.Parameters.Add(new IngresParameter("Number", intNumber));
IngresParameter parm =
new IngresParameter("SSN", IngresType.VarChar);
parm.Value = strSSN;
cmd.Parameters.Add(parm);
IngresDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
if (reader.IsDBNull(0))
break;
strName = reader.GetString(0);
}
reader.Close();
conn.Close();
return strName;
}