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;

}