SqlConnection c = Data.OpenConnection();
SqlCommand cmd = new SqlCommand("AddContactName", c);
cmd.Connection = c;
cmd.CommandType = CommandType.StoredProcedure;
SqlParameter retval = new SqlParameter();
retval = cmd.Parameters.Add("@RETURN_VALUE", SqlDbType.Int);
retval.Direction = ParameterDirection.ReturnValue;
SqlParameter fn = new SqlParameter();
fn = cmd.Parameters.Add("@fName", SqlDbType.VarChar, 25);
fn.Direction = ParameterDirection.Input;
fn.Value = m_fname;
SqlParameter ln = new SqlParameter();
ln = cmd.Parameters.Add("@lName", SqlDbType.VarChar, 15);
ln.Direction = ParameterDirection.Input;
ln.Value = m_lname;
SqlParameter cid = new SqlParameter();
cid = cmd.Parameters.Add("@contactType", SqlDbType.Int);
cid.Direction = ParameterDirection.Input;
cid.Value = m_type;
cmd.ExecuteNonQuery();
contactID = Int32.Parse(cmd.Parameters[0].Value.ToString());
Data.CloseConnection(c);