Database

OleDbCommand command = _databaseConnection.CreateCommand();<br />
      command.CommandText = "SELECT * FROM MEMBERS WHERE fname like '?*' AND lname like '?*'";<br />
      command.Parameters.Add(new OleDbParameter("fname",firstName));<br />
      command.Parameters.Add(new OleDbParameter("lname", lastName));<br />

//this one adds a person(actually not this one but similar with extra fields)
PARAMETERS inName Text ( 255 ), inAdress Text ( 255 );//more but let's simplify
INSERT INTO Person( Name, Adress )
VALUES(inName, inAdress);

//something like this gets the ID
PARAMETERS inName Text ( 255 ), inAdress Text ( 255 );
SELECT Person.ID
FROM Person
WHERE (Person.Name= [inName]) AND (Person.Adress= [inAdress]);

 public class Person : IComparable<Person>
    {
        public int ID { get; set; }
        public string Name { get; set; }
        public string Adress { get; set; }

        public int CompareTo(Person other)
        {
            int equality = this.Name.CompareTo(other.Name);
            if (equality < 0) return -1;
            else if (equality == 0)
            {
                return this.Adress.CompareTo(other.Adress);
            }
            else
            {
                return 1;
            }
        }
    }


//and here is the code that inserts the Person and then gets the ID

int id = 0;
            try
            {
                con.Open();
                //insert the person
                OleDbCommand cmd = new OleDbCommand();
                cmd.CommandText = "EXEC procAddPerson";
                int result = cmd.ExecuteNonQuery();

                if (result == 1)
                {
                    //get the ID by changing the comand text to execute the GetID query
                    cmd.CommandText = "EXECUTE procGetPersonID";
                    id = Convert.ToInt32(cmd.ExecuteScalar());
                }
            }
            catch
            {
                id = -1;
                //log and stuff
            }
            finally
            {
                if (con.State != ConnectionState.Closed)
                {
                    con.Close();
                }
                con = null;
            }

            return id;

con.Open();
//insert the person
OleDbCommand cmd = new OleDbCommand();
cmd.CommandText = "EXEC procAddPerson";
int result = cmd.ExecuteNonQuery();

if (result == 1)
{
    //get the ID by changing the comand text
    cmd.CommandText = "Select @@Identity";
    id = Convert.ToInt32(cmd.ExecuteScalar());
}